| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Attaching a macro to a VB button on a form
I have created a macro to select a row, copy it and then paste it below the
copied row. I want to attach this macro to a VB button labelled "Add Row" but cannot work out how. |
|
#2
|
|||
|
|||
|
"WildGlio" wrote: I have created a macro to select a row, copy it and then paste it below the copied row. I want to attach this macro to a VB button labelled "Add Row" but cannot work out how. Hi, First off you need to make a "Forms" button not a "Control" button. A macro can not be assigned to a "Control" button. After you make the button a window will popup to assign the macro to the button. Just pick your macro from the list. Regards, Marc |
|
#3
|
|||
|
|||
|
Many thanks Marc. I had not noticed the difference between the two
Toolbarmenus. I've got that bit working - thanks again. "Marc W." wrote: "WildGlio" wrote: I have created a macro to select a row, copy it and then paste it below the copied row. I want to attach this macro to a VB button labelled "Add Row" but cannot work out how. Hi, First off you need to make a "Forms" button not a "Control" button. A macro can not be assigned to a "Control" button. After you make the button a window will popup to assign the macro to the button. Just pick your macro from the list. Regards, Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete a macro button is grayed out. | Excel Worksheet Functions | |||
| how to run macro in userform button | Excel Discussion (Misc queries) | |||
| Assigning a macro to a "button" | Excel Discussion (Misc queries) | |||
| How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
| A "previous" button on a user form | Excel Discussion (Misc queries) | |||
Hybrid Mode
