| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i make a button from a userform exit onto the document in .
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i make a button from a userform exit onto the document in .
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Exit button on a UserForm | Excel Discussion (Misc queries) | |||
| Excel 2002 SP3 - Exit button is not available - grayed out. | Setting up and Configuration of Excel | |||
| Use the X button on a userform | Excel Discussion (Misc queries) | |||
| How do i create a command button or macro to exit Microsoft Excel | Excel Worksheet Functions | |||
| I can't turn off excel programs with the exit button. What is up. | Excel Discussion (Misc queries) | |||
Hybrid Mode
