how do i make a button from a userform exit onto the document in .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a userform that i created in VBE on excel but i don't know how to make
a macro on the actual document to take me from it to the form or make a
button from the form take me back to the document, could anyone give me an
answer, it's for my coursework and i need some help! Thanks
 
Put a button the worksheet and assign it to a macro, say "Pieface"
Sub PieFace()
Userform1.Show
End Sub

A button on the form, to "get back to" the worksheet simply does Unload me:
Sub CloseButton()
Unload Me
End Sub

HTH
Bob Umlas
Excel MVP
 
Back
Top