Help with macros

[alsenior]

i need some help making some macros for my AS ict project.

i need two macros to do the following :

• clear a sheet and go to menu sheet(working now)
• close ther sheet and close excel(not working but not needed)
• when a button is clicked a radio button is clicked i need to use a formula to work out a figure and than add it to the overall figure

can someone point me in the right dirction i need the macros pretty quickly i know how to change the sheet but clearing the sheet is harder and i don't know if closing excel is possable

[toolsong]

As with any VBA the simplest place to start is:

1) Record the steps you want to automate.
2) Look at the generated code for the objects and methods it uses.
3) Read VBA help for the above objects and methods.
4) Modify recording to fit your task and make it more easily reused.

[alsenior]

i still need more help but i have got the first two working i need help getting this lasdt one to work i dont think i am able to record that type of macro and the internet is useless for this.

[toolsong]

...and the internet is useless for this.

I'm not sure how you came to that conclusion? I've never had any trouble finding code samples (for any language) and you've not asked anything that isn't in the sample code provided in the VBA Help files.

To implement #3, the first thing you need to do is make sure you have the "Control Toolbox" toolbar visible.

This will allow you to draw a command button (correct) or radio button (wrong object for this purpose) onto the page and write some code for its "click" event.

Right click the button and select "View code" to open the VBA editor.