Thread: Dynamic Data fetching from DB and populate in a cell

In the worksheet,there are two dropdowns as Wheeler Type, Vehicle in cells A1,B1 respectively. There are different types of Vehicles information which are stored in database. lets say 3 Wheeler--Auto, Rikshaw, Moped....4Wheelers--Car, Van, Lorry..
In work sheet you have values in Wheeler type dropdown are 3,4..If i am selecting wheeler type as 3, it should populate the 3 wheeler vehicles Auto,Rikshaw,Moped from the database dynamically to the Vehicle dropdown (B1).Please suggest us the solution to implement the above scenario.

Thanks in advance.

Lakshmi

I guess you're after this....

http://www.contextures.com/xlDataVal02.html

I had the same kind of problem earlier

http://www.excelforum.com/excel-prog...combo-box.html

Thanks for your reply.But for my situation i have to get the list from the DB each and every time i change the value in a cell say A1 and assign to the list of the parallel cell say B1

Where might this database be?
Could you attach an example file?