I am having trouble with retrieving the value of the selected item in the listbox. Each value in the listbox is the name of a city. Each city has a corresponding hidden worksheet that bears the name of the city. I have a button on the userform that when pressed unhides and selects the correct cities worksheet (correct meaning it is the city that is selected in the listbox.) .Right now I have this code to find the value, but I am having trouble with it. Thanks for any help!


Private Sub cmdViewData_Click()
Dim i As Integer

For i = 0 To LBCities.ListCount - 1
Next i
End Sub