Drop Down List Choice gives Different Checkboxes

[AdamParker]

Hello,

I am not sure if this is the correct forum, I assume there would be VBA behind something like what I am trying to do.

Very simple example, I have a drop down list that contains 2 items:
- Staff
- External Users

Now I have several checkboxes that I would like to have available to the user after they have selected their choice from the drop down.

So if someone chooses Staff, they could have the following checkboxes displayed:
- CheckBox 1
- CheckBox 2
- CheckBox 3

And if someone chose External Users, they would instead have these:
- CheckBox 4
- CheckBox 5

Then the user can check whichever boxes are applicable to them and export the document appropriately, is this possible? If you require further clarification please let me know and I will try to be more specific. Any resources you can point me to would be greatly appreciated. Thanks,

Adam

[rylo]

Adam

Say your drop down box is in A1 on sheet1, then right click the sheet tab, select view code and add the code

Please Login or Register  to view this content.

Assuming you already have your checkboxes on the sheet, then change your value in A1 and the relevant checkboxes should appear.

HTH

rylo