Everyone,
I am after a bit of help and guidance!
I have a worksheet which requires one cell to be validated with 3 options of potential answers A/B/C
This is in the form of a drop down list.
There follows another box which needs to be in list format, however if in the previous box 'A' is selected then it requires one list of options to be used. If 'B' it requires a diffetrent list to be shown, and if 'C' then another list to be shown.
I assume if will be similar to an 'IF' 'THEN' command being used somehow?
Can anyone help?
These are called DependentDropBoxes. Here's a link to a sample sheet showing how this done...and some further reading material:
http://www.excelforum.com/attachment...dentlists2.xls 2 levels
http://www.excelforum.com/attachment...ndentlists.xls 3 levels
http://www.excelforum.com/attachment...elfsorting.xls
http://www.contextures.com/xlDataVal13.html 'more reading
http://contextures.com/xlDataVal02.html 'more reading
Last edited by JBeaucaire; 04-27-2009 at 11:07 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks