Hey guys, new to the forum and looking for some help!
I have a workbook with several drop down boxes and formulas already set up and working. I want to improve it though. My question is.... is there a formula that will make the drop down list change based on a cell value....
For example: If B6 equals vegetables then C6 equals list (potato, carrot, pea, etc.) If B6 equals fruit then C6 equals list (apple, banana, grape)
Would love some advice and help!! thanks!
Last edited by VBA Noob; 10-23-2008 at 03:16 PM.
Try this link
http://www.contextures.com/xlDataVal02.html
Is that what you want?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
yes and no.... I've got that part... let me better explain my situation... I work for an a/c company and I'm making a spreadsheet that more or less looks like the following:
Vendor:
Air Conditioner:
Furnace:
Coil:
I want to be able to say if the within the vendor cell "Carrier" is chosen then only Carrier model numbers show up in each of the following cells. I can do this with one... but it gets tricky when I try to distinguish between Air Conditioners and Furnaces and Coils. Perhaps I need to have two distinguishing factors... if it is a Carrier unit and a Furnace then here is your list... If it is Carrier and an Air Conditioner then this list.
Yes, you need separate lists for each of the cells. Namewise, for Airconditioning, I used Vender+AC (e.g. CarrierAC), Furnaces: Vender +Fur, Coils: Vender+Coils. Then for each dropdown in Validation (where B1 is my Vender choice), I concatenated them like soI attached my example. Does that work for you?
Please Login or Register to view this content.
YES! That is exactly what I need.... now let's see if I can make it work on my own!! I'll let you know how it turns out! Thanks!
Thank you thank you thank you Chemist B!!! It works.... You are great.
Glad it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks