calling a userform

[rodney_malodney]

how do i run or open a userform when a command button is clicked??

 

[jindon]

Hi

Userform1.Show

 

[Jeggburt]

Depending on what you call your command button and userform:

private sub CommandButton1_Click()

UserForm.Show

end sub

 

[Richard Schollar]

If it's a command button on a userform, place the following code in the userform code module:

Private Sub CommanButton1_Click()

UserForm2.Show  'or whatever your userform is called

End Sub

Best regards

Richard