Excuse further ignorance, please, but is the Activate event
the same as the Initialise Event? I have the following in the
original form for _Initialise (but nothing for an _Activate
Event):
Private Sub UserForm_Initialize()
'Fill the ListBoxes
With GetUserPrintOptions.ListBox1
.RowSource = ""
.AddItem "You want to print EVERY Worksheet in EVERY chosen Workbook"
End With
With GetUserPrintOptions.ListBox2
.RowSource = ""
.AddItem "You will want to hide Column(s)"
End With
With GetUserPrintOptions.ListBox3
.RowSource = ""
.AddItem "You want to include the printing of pages that total '0.00'"
End With
With GetUserPrintOptions.ListBox4
.RowSource = ""
.AddItem "You want to include the printing of pages with no totals"
End With
End Sub
Many thanks,
Regards,
"Jim Rech" wrote in message
...
You don't have any code in the original userform's activate event to reset
the list boxes, do you? The .Show after closing the second form would run
it.
--
Jim Rech
Excel MVP
---
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