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![]()
Bookmarks