so when the user selects a 31Belt, the code will (1) clear the door opening
sizes from the listbox then (2) add the door options for that particular
belt

I can send a file to you directly if you would like to see what i mean...
excel; 2003 or 2007

"Cerberus" wrote in message
...
Thank you for your response

I not sure a LISTBOX would work well with all the variables I have. See,
I
have 6 different belt sizes, 6 different door options and 26 different
door
openings. While the 25Belt option has up to 11 door opening options and
31Belt has 8, the 48Belt option only has 1. I don't want to give the
impression that you could have multiple options to the belts that are
limited
to one opening size.

Now of course you have much more experience than I do about all of this,
so
if you know of a trick to make a LISTBOX work properly I would be more
than
happy to listen to your idea.

"Patrick Molloy" wrote:

your code looks fine so long as you have a userform called Opening

why don't you populate a LISTBOX with the available sizes?

"Cerberus" wrote in message
...
I'm relatively new to programming so forgive me if I have trouble
conveying
my question properly. Is it possible to show a new UserForm based on
meeting
three criteria? In my case, I have multiple door sizes that are
available
but only when a certain criterion have been met, i.e. "25belt-full
swing-flip
up" has multiple opening sizes but a "48belt-full swing-flip up" only
has
one
size.

Now I want to make a UserForm "pop up" when the conditions are right,
that
have the opening sizes so I don't have too many grayed out selections
when
choices are not applicable. So in the example above I would think I
need
something like (and this is where I have the lack of knowledge):

If Start.Option25belt.Value = True And _
Door.OptionFullSwing.Value = True And _
Door.OptionFlipUp.Value = True Then
Opening.Show
End If

I'm sure that is not even close to being correct but I hope it helps
give
a
understanding of what I'm looking for. Thank you in advance for any
assistance.