Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for Buttons
I have a simple copy and paste macro which pulls from a
range in one workbook to another. How can I assign that macro to a command button (from forms)? It can't be a menu button becuase I will have too many. Does the button call the macro or do I need additional code (under view code). I tried to copy my macro code but didn't work. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for Buttons
put the button on the sheet (from the forms toolbar), right click on it and
select assign macro. Actually, when you draw the button on the sheet, you should get prompted with a dialog to assign a macro. Once assigned, when you press the button, the button fires the macro. -- Regards, Tom Ogilvy Mike wrote in message ... I have a simple copy and paste macro which pulls from a range in one workbook to another. How can I assign that macro to a command button (from forms)? It can't be a menu button becuase I will have too many. Does the button call the macro or do I need additional code (under view code). I tried to copy my macro code but didn't work. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for Buttons (Hey, Tom)
Thanks, Tom, however it's not working like that for me. I
have Office XP and when I create a button it does not ask to assign macro nor does it have "assign macro" when right clicked. I have view code which opens a blank VBA space for me to author a routine for the button (onclick). Help also indicates to use View Code. How should I approach this? Mike -----Original Message----- put the button on the sheet (from the forms toolbar), right click on it and select assign macro. Actually, when you draw the button on the sheet, you should get prompted with a dialog to assign a macro. Once assigned, when you press the button, the button fires the macro. -- Regards, Tom Ogilvy Mike wrote in message ... I have a simple copy and paste macro which pulls from a range in one workbook to another. How can I assign that macro to a command button (from forms)? It can't be a menu button becuase I will have too many. Does the button call the macro or do I need additional code (under view code). I tried to copy my macro code but didn't work. Thanks. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for Buttons (Hey, Tom)
I'm not Tom, but that sure sounds like you used the commandbutton from the
Controltoolbox toolbar (not the Forms toolbar). I'd double check one more time. Mike wrote: Thanks, Tom, however it's not working like that for me. I have Office XP and when I create a button it does not ask to assign macro nor does it have "assign macro" when right clicked. I have view code which opens a blank VBA space for me to author a routine for the button (onclick). Help also indicates to use View Code. How should I approach this? Mike -----Original Message----- put the button on the sheet (from the forms toolbar), right click on it and select assign macro. Actually, when you draw the button on the sheet, you should get prompted with a dialog to assign a macro. Once assigned, when you press the button, the button fires the macro. -- Regards, Tom Ogilvy Mike wrote in message ... I have a simple copy and paste macro which pulls from a range in one workbook to another. How can I assign that macro to a command button (from forms)? It can't be a menu button becuase I will have too many. Does the button call the macro or do I need additional code (under view code). I tried to copy my macro code but didn't work. Thanks. . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reset button code for Radio Buttons | Excel Discussion (Misc queries) | |||
Code for Command Buttons | Excel Discussion (Misc queries) | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) |