I want to add a button that say"calculate", The user would click on this
button and a macro would run that would do the necessary calcualtions. How
do I get a button inserted into my workbook to which I can assign a macro.
I want to add a button that say"calculate", The user would click on this
button and a macro would run that would do the necessary calcualtions. How
do I get a button inserted into my workbook to which I can assign a macro.
Right click on any menu and select the Forms menu. From there select the button icon and draw the button where you want it on the worksheet. When you have done that a dialog will appear to assign a macro to the button.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks