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.