Drop down list

[imlearningexcelvba]

Hi,

I have 10 columns. 2 columns are drop down list. The excel is calling from SQL table. Drop down list are also maintain in SQL Table.
How can I create dependent drop down that rely to first drop down?

Example:

ColumnA drop down selected Volvo, columnB should automatically show Blue and Dark Blue color.

I try to google, but most of the example are ready list with formula. But my case the drop down list reading from SQL data table. Any advice?

 

[onlyadrafter]

Hello,

look at this post

cascading combo boxes...???

is there any way in which I can get the selection from one combo box to influence the second?? In other words, The second combo box is dependant on the first. I am using Excel XP. any help would be appreciated. cheers

www.mrexcel.com

Look at the fourth post by Aladin

it may be what you want. Not sure about the SQL side of things though.