Since you're displaying UserForm2 as a modal dialog, you can call the
commandbutton2_click subroutine in the Activate event of Userform2. So, in
UserForm2 code module:

Private Sub UserForm_Activate()
CommandButton2_Click
End Sub



--
Hope that helps.

Vergel Adriano


"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