| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically click CommandButton
The following expression works fine and clicks CommandButton #1:-
Call UserForm1.CommandButton1_Click Is it possible to assign a variable to the number of the button clicked, along the lines:- For X=1 to 5 step 1 Call UserForm1.CommandButton(X)_Click (Then does what clicking the CB does) Next X This doesn't work, but I don't know if the fault is incorrect syntax, or that the expression simply cannot take a variable. donwb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| after click a button(commandbutton), getting the button name | Excel Programming | |||
| Capture/Passing Commandbutton click | Excel Programming | |||
| DTPicker Control: Can you programatically fire the click event? | Excel Programming | |||
| Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
| Mouse Over Graph, Capture Information on Click(Double Click) | Excel Programming | |||
Threaded Mode
