Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quitting a User Form
Rocky,
Thanks for the reply. But, how do you load a user form into Excel? It doesn't seem obvious to me. Bob "Rocky McKinley" wrote in message ... Hi Bob, If you load the userform from Excel it should return to Excel when you unload, however if you load it from the Visual Basic Editor then it will return to the Visual Basic Editor when you unload. So probably just try loading it from Excel. Regards, Rocky McKinley "Bob Kaku" wrote in message news:D5N_a.100630$Oz4.23865@rwcrnsc54... I'd like to have a button that quits the execution of a user form and returns to Excel. Right now, I have the "Unload Me" command within the quit button. But, clicking that button leaves me within the Visual Basic Editor. I'd like to get out all the way back to Excel. Thanks in advance. -- Bob Kaku Email: http://www.majesty.org |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quitting a User Form
Bob,
Userform1.Show steve "Bob Kaku" wrote in message . net... Rocky, Thanks for the reply. But, how do you load a user form into Excel? It doesn't seem obvious to me. Bob "Rocky McKinley" wrote in message ... Hi Bob, If you load the userform from Excel it should return to Excel when you unload, however if you load it from the Visual Basic Editor then it will return to the Visual Basic Editor when you unload. So probably just try loading it from Excel. Regards, Rocky McKinley "Bob Kaku" wrote in message news:D5N_a.100630$Oz4.23865@rwcrnsc54... I'd like to have a button that quits the execution of a user form and returns to Excel. Right now, I have the "Unload Me" command within the quit button. But, clicking that button leaves me within the Visual Basic Editor. I'd like to get out all the way back to Excel. Thanks in advance. -- Bob Kaku Email: http://www.majesty.org |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user form | Excel Discussion (Misc queries) | |||
User Form | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Search function keeps quitting in Excel | Excel Worksheet Functions | |||
Error appearing after quitting from MS EXCEL 2003 SP1 | Excel Discussion (Misc queries) |