| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
generating sheet with command button & code
Hey everybody,
I'm a little new to Excel soln dev so bear with me... I have a master workbook with a button that generates other workbooks. That works fine but now I have to include a button (cmdGo) with corresponding code (cmdGo_Click()). How do I do this in the code of the master workbook? Any help, direction or example would be greatly appreciated. Thanks a lot in advance! Bob (please reply to group) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
generating sheet with command button & code
On Mon, 4 Aug 2003 01:44:26 -0700, Bob wrote:
Hey everybody, I'm a little new to Excel soln dev so bear with me... I have a master workbook with a button that generates other workbooks. That works fine but now I have to include a button (cmdGo) with corresponding code (cmdGo_Click()). How do I do this in the code of the master workbook? Any help, direction or example would be greatly appreciated. Thanks a lot in advance! Bob (please reply to group) Did you define a procedure name? If so, try this: ********** Private Sub cmdGo_Click() Call MyProcedure End Sub ********** This will start the procedure 'MyProcedure', which should be included in the workbook. Good luck... SL |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
generating sheet with command button & code
Thanks for the reply but I'm looking for something a bit
different. I'm sorry I didn't make myself clear. I need to place a command button with corresponding code in the GENERATED workbook (say, on Sheet2). I need to do this from the code of the master workbook. Any ideas of how to accomplish this? -----Original Message----- On Mon, 4 Aug 2003 01:44:26 -0700, Bob wrote: Hey everybody, I'm a little new to Excel soln dev so bear with me... I have a master workbook with a button that generates other workbooks. That works fine but now I have to include a button (cmdGo) with corresponding code (cmdGo_Click ()). How do I do this in the code of the master workbook? Any help, direction or example would be greatly appreciated. Thanks a lot in advance! Bob (please reply to group) Did you define a procedure name? If so, try this: ********** Private Sub cmdGo_Click() Call MyProcedure End Sub ********** This will start the procedure 'MyProcedure', which should be included in the workbook. Good luck... SL . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
generating sheet with command button & code
Look at Chip Pearson's site for programming the VBE
http://www.cpearson.com/excel/vbe.htm You can turn on the macro recorder and get the code for adding a button. John Walkenbach also has sample code for creating controls on a userform dynamically. It should still be useful for creating controls on a sheet http://www.j-walk.com/ss/excel go to developer tips and then tips on userforms. Regards, Tom Ogilvy "Bob" wrote in message ... Thanks for the reply but I'm looking for something a bit different. I'm sorry I didn't make myself clear. I need to place a command button with corresponding code in the GENERATED workbook (say, on Sheet2). I need to do this from the code of the master workbook. Any ideas of how to accomplish this? -----Original Message----- On Mon, 4 Aug 2003 01:44:26 -0700, Bob wrote: Hey everybody, I'm a little new to Excel soln dev so bear with me... I have a master workbook with a button that generates other workbooks. That works fine but now I have to include a button (cmdGo) with corresponding code (cmdGo_Click ()). How do I do this in the code of the master workbook? Any help, direction or example would be greatly appreciated. Thanks a lot in advance! Bob (please reply to group) Did you define a procedure name? If so, try this: ********** Private Sub cmdGo_Click() Call MyProcedure End Sub ********** This will start the procedure 'MyProcedure', which should be included in the workbook. Good luck... SL . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
generating sheet with command button & code
Bob,
Why not create a template file (or sheet) with the controls alread embedded and add the data to that, then save as a new file? Alex@JPCS "Tom Ogilvy" wrote in message ... Look at Chip Pearson's site for programming the VBE http://www.cpearson.com/excel/vbe.htm You can turn on the macro recorder and get the code for adding a button. John Walkenbach also has sample code for creating controls on a userform dynamically. It should still be useful for creating controls on a sheet http://www.j-walk.com/ss/excel go to developer tips and then tips on userforms. Regards, Tom Ogilvy "Bob" wrote in message ... Thanks for the reply but I'm looking for something a bit different. I'm sorry I didn't make myself clear. I need to place a command button with corresponding code in the GENERATED workbook (say, on Sheet2). I need to do this from the code of the master workbook. Any ideas of how to accomplish this? -----Original Message----- On Mon, 4 Aug 2003 01:44:26 -0700, Bob wrote: Hey everybody, I'm a little new to Excel soln dev so bear with me... I have a master workbook with a button that generates other workbooks. That works fine but now I have to include a button (cmdGo) with corresponding code (cmdGo_Click ()). How do I do this in the code of the master workbook? Any help, direction or example would be greatly appreciated. Thanks a lot in advance! Bob (please reply to group) Did you define a procedure name? If so, try this: ********** Private Sub cmdGo_Click() Call MyProcedure End Sub ********** This will start the procedure 'MyProcedure', which should be included in the workbook. Good luck... SL . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| command button code | Excel Discussion (Misc queries) | |||
| Code for my Command Button to automatically copy and insert a new | Excel Discussion (Misc queries) | |||
| VBA code behind command button | Excel Worksheet Functions | |||
| Command Button VBA code | Excel Discussion (Misc queries) | |||
| Create Command Button from Code | Excel Programming | |||
![Bob[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
