| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to execute a CommandButton_Click macro without clicking on
Hi,
The Userform2 is opened from a Userform1 click. So, at the execution of the CommandButton1, after UserForm2.Show line, I'm wondering if it's possible to execute the macro inside CommandButton2_Click as if the user clicked on. Thanks!! Alex Private Sub CommandButton1_Click() UserForm1.Hide Load UserForm2 UserForm2.CommandButton2.BackColor = RGB(166, 182, 214) UserForm2.CommandButton2.SetFocus 'Something like Userform2.Browse.ExecuteMacro ?? UserForm2.Show End Sub -- Alex St-Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use VB code to execute macro when double-clicking cell? | Excel Programming | |||
| How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
| commandbutton_click problem | Excel Programming | |||
| Clicking on a cell to execute a routine | Excel Programming | |||
| Userform - CommandButton_Click question | Excel Programming | |||
Threaded Mode
