Link to User form

[gregork]

I have a button on a user form that I want to command another user form to
open. How do I do this using VBA code?

gregork

 

[Hank Scorpio]

I have a button on a user form that I want to command another user form to
open. How do I do this using VBA code?

You want a second user form to open a button??

I'm guessing that you actually mean that you want a command button on
one user form to open a second user form. (If that's not it, please
post again with more details.)

You can do that by simply entering the following code. (CommandButton1
is on a form called UserForm1, and UserForm2 is the form that is to be
opened.)

Private Sub CommandButton1_Click()

UserForm2.Show

End Sub

 

[gregork]

Yes Hank that was exactly what I meant.

Many thanks.
gregork