Filtering list boxes

[nk0410]

I have many list boxes that I use on an order form spread sheet. I'm trying to find a way to filter data from one list box to another. For example:
I have a list box for all vehicle makes, like Chevrolet and Buick and so on. I want the second list box to generate a list of models for Chevrolet. But if I select Buick, I need that models list box to only give me models by Buick. If anyone has any tips to point me in the right direction, I would be extremeley greatful.
Thanks for any help, nk0410.

 

[erik.van.geit]

Hello, nk0410
Welcome to the Board !!!!!

take a look at this "famous" thread
(the link is already pointed to the "most relevant post")

http://www.mrexcel.com/board2/viewt...=0&postorder=asc&highlight=cascading&start=26

for a technique using comboboxes
http://www.mrexcel.com/board2/viewtopic.php?t=152281&start=5

kind regards,
Erik