Zander has attended:
Excel Intermediate course
Macro, adding button.
I would very much like to find out how to add a button that would add an amount to an existing macro spreadsheet.If you could assist it would be greatly appreciated.
RE: Macro, adding button.
Firstly you need to be able to do the steps manually, before you record a macro.
Once you have confidence that the manual steps work, then record the macro using TOOLS > MACRO > START RECORDING.
Once you have a macro recorded and it works, you can then attach that macro to a button by doing the following:
1. Show the FORMS toolbar (View > Toolbars > FORMS)
2. click the command button icon to activate
3. Draw an area when you would like to have the button appear.
4. Assign the macro, with thw wizard, or right click on the button, then ASSIGN Macro
5. Size and position the button as required.
