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

"Pieface" wrote in message
...
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