Cascading Drop Down Boxes

well i still cant get it to work using drop down boxes, using similar code

Sub DropDown96_Change()

If DialogSheets("Enter Game").DropDown("95").Value = Sheets("Game Info").Range = ("E22") Then
DialogSheets("Enter Game").DropDown("96").Value = Sheets("Game Info").Range = ("A22$:A26")

End If
End Sub

I know im probably doing all this wrong as i have only been doing VB for bout 3 weeks :P


nd im sure u can help me jst alittle

anymore help appriciated!