Cascading Drop Down Boxes

[Gibsie]

Hi,

I New to Excel and was wondering if you could help me with a problem im having.

Im makingg a spreadsheet on which you input Game data such as, Hardware type Game name rating etc(pointless i know but its for college)

Anyway im trying to make it possible to select the platform and then a preset list of game comes up. But i jst cant get it to work. Ive attached my spreadsheet so u can have a look

Thanks for any help

Just so you know, This is the code ive attempted to use, but Excel doesnt like it.

Sub ListBox14_Change()

If DialogSheets("Enter Game").EditBox("10").Value = Sheets("Game Info").Range = "$E$22" Then
DialogSheets("Enter Game").ListBoxes("14").Value = Sheets("Game Info").Range = "A$22$:$A$26"

End If


End Sub