INDIRECT drop down menus for seperate words.

dno_ca

New Member
Joined
Oct 6, 2002
Messages
9
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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Mudface

MrExcel MVP
Joined
Feb 18, 2002
Messages
3,339
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

MrExcel MVP
Joined
Feb 18, 2002
Messages
2,607
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

New Member
Joined
Oct 6, 2002
Messages
9
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
 

Forum statistics

Threads
1,144,361
Messages
5,723,905
Members
422,526
Latest member
edminty84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top