| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW CAN I WRITE A CODE TO A COMMANDBUTTON CREATED PROGRAMMATICALLY
My first question is how can I write a code to A CommandButton added by the
code below. Private Sub Workbook_Open() Set MyCommandButton = UserForm1.Controls.Add ("Forms.CommandButton.1", "CommandButton1" ) End Sub My second question is, is there a way to create a UserForm programmatically? (As my project above, I had to create a UserForm manually first and then invoked the code above to add a CommandButton to my UserForm.) -- Kozete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW CAN I WRITE A CODE TO A COMMANDBUTTON CREATED PROGRAMMATICALLY
Kozete
Have a look at this page as I think it will answer both your questions. http://www.tek-tips.com/faqs.cfm?fid=5757 Cheers Rui "Kozete" wrote: My first question is how can I write a code to A CommandButton added by the code below. Private Sub Workbook_Open() Set MyCommandButton = UserForm1.Controls.Add ("Forms.CommandButton.1", "CommandButton1" ) End Sub My second question is, is there a way to create a UserForm programmatically? (As my project above, I had to create a UserForm manually first and then invoked the code above to add a CommandButton to my UserForm.) -- Kozete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW CAN I WRITE A CODE TO COMMANDBUTTON ADDED AT RUNTIME? | Excel Programming | |||
| problem with Excel file created programmatically | Excel Programming | |||
| CommandButton - Created using Forms toolbar | Excel Discussion (Misc queries) | |||
| use vba to write vba for a chart sheet created on the fly | Excel Programming | |||
| Data from Programmatically created Excel into SQL Server | Excel Programming | |||
Linear Mode
