View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default How to execute a CommandButton_Click macro without clicking on

Hi
Commandbutton2 must call a macro, so simply do

Call myMacro

Your Commandbutton2_Click macro would be

Private sub Commandbutton2_Click ()
Call myMacro
End sub

and myMacro would be in a normal code module (cut and paste your
existing code out of Commandbutton2_Click ).
regards
Paul

On Mar 22, 6:23 pm, Alex St-Pierre
wrote:
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