"Dando265" wrote:

Hi,
I'm stuck trying to create three dependant lists from a selction of
another list.

My Products are shutters made from different materials,(1st list)
Craftwood, Lockwood, and Basswood.

Each of these products have different louvre options (1st dependant on
list1)
They also have diffent frame options (2nd list dependant on list1)
And finally they have different colours (3rd list dependant on list1)

Can anyone help me please, i'm really struggling with this.

Thanks

Dando265

Hello,

I think you would do best with a "Case" statement:
Private Sub Image_Change()
Select Case Me.Image.Value

Case "IPSD Base"
With Me.Project
.Clear
.AddItem ""
.AddItem "N/A"
End With
Case "CPSE Base"
With Me.Project
.Clear
.AddItem ""
.AddItem "N/A"
End With
Case "CPSE Development"
With Me.Project
.Clear
.List = Array(" ", "AMA", "ATHN", "Feller", "Future", "Phoenix",
"Janus", "K700", "KMS", "MEGA", "PSD", "SEBR")
End With
End Select
End Sub

Note that this something I made for 2 dropdown lists. If the user chooses
"CPSE" in the first list, the 2d list displays the choices "AMA", "ATHN",
"Feller", "Future", "Phoenix", "Janus", "K700", "KMS", "MEGA