How to create checkbox in a drop down list?

[hnd]

Hi,

I need help in creating checkbox in a drop down list. Based on first multiple selection, second checkbox dropdown list to be populated according to the first selection.

Request for help.

Thanks & Regards,
hnd

 

[Debraj]

Hi hnd..

any sample file .. for your imagination ....

are you talking about user form or excel sheet..
Dropdown with multiple choice.. I think.. List box & user form is required in this case..

 

[hnd]

Hi,
Please find attached file. I am looking at this in excel sheet.
I select category, sub-category and then select the rest of the details to arrive at final value.
I can select more than one in section ie., I can select one category or two category, then one sub-category under main or multiple, etc...

Hope this helps to understand the requirement.

Thanks & regards,
hnd

 

[bobhc]

You can achieve what you want with dependent data validation


http://www.contextures.com/xlDataVal02.html



.

 

[Avimit]

You will have to use ListBoxes with VBA code.
here is a completely free solution to dowload with code.
http://www.vlsiip.com/exceltips.html