Excel 2007 : Dependent DropDown lists

Hi ive been working with excel over the past few days trying to create a number of dependent drop down lists for a Variant Request Fourm.

The goal is to create a customer friendly order fourm where all one has to do is select a product which will trigger all the avalible features accosiated with it.

For example: MLL-1001 is selected in dropdown box 336.

Therefore in the colour option dropdown box only grey, black and white should appear rather than the full option of colours.

I have been hunting on other sites for ways to accomplish this using VBA code but I have had no success. This is an example of what i have been trying to do.

Sub DropDown364_Change()

Select Case DropDown364.Text
Case "MLL-1001"
ActiveSheet.Shapes("DropDown365").Select
Selection.ListFillRange = "B13:B16"
ActiveSheet.Shapes("DropDown339").Select
Selection.ListFillRange = "C3:C6"
ActiveSheet.Shapes("DropDown342").Select

End Select
End Sub

If anyone could offer me some advice it would be very much appreciated

Hi Harrison

Is there any particular reason for doing this with VBA, you should be able to do it relatively easily without any code.

Can you post a sample spreadsheet?