Closing user form in Initialize macro?
Another possibility.
Load the userform. Check if the Combobox has any items (Combobox1.ListCount
0) and then proceed. appropriately.
something like
Load UserForm1
If UserForm1.ComboBox1.ListCount 0 Then
UserForm1.Show
Else
Unload UserForm1
End If
where the UserForm's Initialize event loads the combobox with MS Access
data.
worked for me.
"Don Wiss" wrote in message
...
I have a situation where the user form Initialize routine can fail to
retrieve data from Access (which is used to populate a combo box). I now
display a msgbox, but I then have to display the form, which of course is
non-functional. I tried using Unload Me, but it didn't work. Presumably
as the form wasn't yet loaded. I would think there must be a way to abort
an initialization and not display the form.
Don <www.donwiss.com (e-mail link at home page bottom).
|