I am definitely new to this VBA world. I am trying to make a userform
listing all the sheets in a very large workbook so I can select on the name
listed. The result would be once the selection is made it would take me to
that sheet. This is the code I have so far....


Private Sub ListBox1_Click()
Sheet.Select
End Sub

Private Sub UserForm_Initialize()
For i = 1 To Sheets.Count
ListBox1.AddItem Sheets(i).Name
Next i
End Sub


What am I doing wrong?


Thanks Ted