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