INDIRECT drop down menus for seperate words.

[dno_ca]

I have a form that I would like to create in excel where from the first drop down column (created by the Data>Validation>List option, NOT visual basic) they could choose between:

1) blue/red
2) dark brown
3) black
4) brown and 2
5) green (bright)
6) dirty-yellow

My problem is that this selected pick from here is supposed to bring up the choices for the next column. I would have done this using the Data>Validation>List=INDIRECT(A1) method BUT the Name Box will not accept special characters such as / or spaces. I'm not sure if there is a workaround for this or if anyone can tell me exactly how to code this in visual basic.

Thanks to all who will help.

Dean

 

[Mudface]

Easy workaround- use underscores for spaces in your first list and don't use any proscribed characters, also think about alternative names. It might make your worksheet look a little bit 'odd' but it'll save you a lot of trouble.

 

[Anne Troy]

Someone just taught me how to do this and sent me a sample file. If you want it, just email Anne@TheOfficeExperts.com. I intend to make it a freebie download eventually. It cares nothing about spaces, etc.

 

[dno_ca]

Thanks guys,

I was wondering if anyone knew the VB code to get the last box to automatically pop up when all the other boxes were filled in.

I will email you anne right away for that example file!

Dean