Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user form question: text box to display result | Excel Discussion (Misc queries) | |||
user form question: text box to display result | Excel Worksheet Functions | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Automatically display sentence. | New Users to Excel | |||
Worksheet form design | Excel Discussion (Misc queries) |