Use of ComboBox in Excel 2007

[Jaffary]

I want to use ComboBox in Excel 2007 with some conditions

Like on first combo(Vehicles) if i select Car second combo(Models) will show the models of cars if i select Bike in 1st cmbo, 2nd cmbo shows bike models

Can any one help me ?

[sayhellotoit]

Wassalam,

You can use filter instead of comboBox.
The sample file is attached.

[Jaffary]

Thanx dear to spare your time

but it works on data available/saved,
i want to use this couple of combo at the time of data posting.

Please review it.