HELP - Dropdown - Conditional Help

[spicekid]

Hi Guys,

I have a dropdown list for which I want the user to select from, however, if the user selects something on the list, I want to then show a number of checkboxes. How would I do this?

What would the code look like?

Many thanks

 

[Michael M]

I don't have EXcel at the moment, but....

I'm guessing you will need a select case statement, depending on the size of the list !

1. How many names are on the list ?
2. Are the checkboxes already created ?
3. how many checkboxes in total AND how many need to be visible
4. Are the names on the list on the same sheet as the checkboxes.

As you can see there is much more information required before someone can give you a comprehensive answer