If your running these combo boxes as sheet form controls I would used the 'validatin' function, if your cbo's are part of the VBA, I'd use a case statement to populate the combo boxes. Can you advise which type of control your useing?
Open the attached book1.zip, to to the vba end of the program, launch (F5) and watch it work. This is an over simplification of the process. In your case where you might be dealing with hundreds of model types, I would probably built this in a different app or if in excel with different conventions.
Originally posted by Chimp8471
I have attached my spreadsheet, so you can see more clearly what i am trying to achieve.
On the spreadsheet there are three worksheets, on the worksheet titled "Sales there is a button called New Sale
when clicked it launches a form to open and this is where i want the cascading options to happen.