| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Thanks to Bob and Earl. Job done
"Earl Kiosterud" wrote: Jock, Command buttons have their own event handlers. Double-clicking one will take you to it, something like: Private Sub CommandButton1_Click() ' you could call your macro in here ' or just put the code here End Sub This event handler lives in the sheet module, like worksheet_change and other events. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Jock W" wrote in message ... How do I allocate a macro to a command button? Right clicking a command button which is in design mode brings down a drop down menu but 'assign macro' isn't on option. -- Jock Waddington |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enabling macros | Excel Discussion (Misc queries) | |||
| sorting with macros | Excel Discussion (Misc queries) | |||
| Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
| The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
| Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
Threaded Mode
