user forms

[tim Shudt]

Lets say I have 3 user forms each with a next button. When I click the
next button I want to open the next form and close the form with the
button that was clicked. Please help

Tim

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Bernie Deitrick]

Tim,

Something like this, for commandbutton1 on userform1:

Private Sub CommandButton1_Click()
UserForm1.Hide
Unload UserForm1 ' only if you don't need it again...
Load UserForm2 ' only if you haven't already loaded it...
UserForm2.Show
End Sub

HTH,
Bernie
MS Excel MVP