Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIFS, one criteria range, multiple criteria | Excel Worksheet Functions | |||
Match / Index multiple criteria return multiple results | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |