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 |
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 |