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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pieface - 17 Apr 2007 16:08 GMT

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

Reply to this Message

Bob Umlas - 17 Apr 2007 19:35 GMT

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

> 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

Reply to this Message