Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro command button click
Hi
Private Sub CommandButton1_Click() UserForm5.Show UserForm5.CommandButton3.SetFocus Unload Me End Sub Regards, Per "Woodi2" skrev i meddelelsen ... I have a macro that opens a userform. I want the macro to open userform 5 then upon opening userform 5 I want command button 3 to be activated. I have made command button 3 public withing the code for userform 5. When the macro is activated, the userform dispalys ok but the command button has not been activated. I thought this might be a simple one but may be I was wrong. Private Sub CommandButton1_Click() UserForm5.Show UserForm5.CommandButton3_Click Unload Me End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro command button click | Excel Programming | |||
Assign Macro to Command button by right click | Excel Programming | |||
Command Button Click | Excel Discussion (Misc queries) | |||
VBA Click Command Button | Excel Programming | |||
How do I set a macro to run when I click a Command Button in Exce. | Excel Programming |