HELP! With List Boxes

[Jerminator]

OK, I hope I can explain what I'm trying to do. I have created a ListBox1 and I used the ListFillRange for my list in the box. Now the problem I'm having is getting the VBA code right so that when a selection in the box is clicked it does the following:

Sheets("Sheet2").Visible = True

Basically to show a very hidden sheet. Can someone help me with the coding of the Select Case code?

 

[Joe Was]

View Code, in click event:

If ListBox1 = whatever Then
Sheets("Sheet1").Visible = True
End If

repeat for as many items as you have in the ListBox List. JSW