View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default Userform will not exit correctly

I have a form which contains 4 listboxes, each
offering a single option. If listboxes 2 to 4 are
selected, then a different listbox is then presented,
again with a single option.

User should be able to cycle through the original
form interacting with the forms behind the listboxes
before finally choosing Ok or Cancel.

What is happening is that when the user makes a
choice in one of the forms behind a listbox, then
when returned to the original form, that listbox may
have been cleared....so they have to go through
the process again.

Here is the _Change code:

Private Sub ListBox2_Change()
Me.Hide
GetUserHideColumnOptions.Show
GetUserHideColumnOptions.Hide
Me.Show
End Sub

Private Sub ListBox3_Change()
GetUserPrintOptions.Hide
GetUserPrintZeroPagesOptions.Show
GetUserPrintOptions.Show
End Sub

Private Sub ListBox4_Change()
GetUserPrintOptions.Hide
GetUserPrintBlankPagesOptions.Show
GetUserPrintOptions.Show
End Sub

What am I doing wrong, please?

Regards.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003