Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default Closing a Form

I have a Form that allows a user to select one of three voltage ranges. Once
a selection is made, I want the form to close. Thus far I have tried using
"Unload frmStartupRange" and "frmStartupRange.Hide" both with no sucess. The
form does not close until there is a display change. I have included some of
the code below. Any help would be greatly appreciated.

Thanks,
Mike

This is the code for the Form:
Private Sub Europe_Click()
WhichRange = "Eu"
Unload frmStartupRange
End Sub
Private Sub Japan_Click()
WhichRange = "Ja"
Unload frmStartupRange
End Sub
Private Sub NorthAmerica_Click()
WhichRange = "NA"
Unload frmStartupRange
End Sub
Private Sub UserForm_Click()
End Sub


 
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 question: text box to display result BigPig Excel Discussion (Misc queries) 0 February 28th 06 12:33 AM
user form question: text box to display result BigPig Excel Worksheet Functions 0 February 25th 06 08:17 PM
Access Form In An Access Report (SubForm) Question Gary Links and Linking in Excel 0 January 27th 06 05:54 AM
Automatically display sentence. Rao Ratan Singh New Users to Excel 2 January 17th 06 06:53 PM
Worksheet form design rgarber50 Excel Discussion (Misc queries) 4 August 7th 05 05:09 AM


All times are GMT +1. The time now is 07:23 AM.

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"