Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 576
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
user form Jase Excel Discussion (Misc queries) 1 March 25th 08 09:51 PM
User Form Joanne Excel Discussion (Misc queries) 1 June 26th 07 02:26 PM
How do I fill a cell in a user form from a selection on same form? Terry Tipsy Excel Discussion (Misc queries) 4 June 11th 07 02:59 PM
Search function keeps quitting in Excel Rebecca[_2_] Excel Worksheet Functions 0 February 20th 07 12:41 AM
Error appearing after quitting from MS EXCEL 2003 SP1 Gianluigi Excel Discussion (Misc queries) 1 January 17th 05 02:37 AM


All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"