Userform Listbox Value

[IBahamut]

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

[MarvinP]

Hi IBahamut

Example 6 on this site shows how to use the index number and "true" if selected..

http://www.globaliconnect.com/excel/...=79&Itemid=475

If that doesn't help then attach your workbook so we can play with the code and make it work.

[IBahamut]

Here is my file. After fiddling around I was able to set a variable and find out the value that way. What I am trying to do is that when I click the View Sales Data button on the userform, I need to go to the sheet with the same name and display a message box saying the total sales for that city. My code is a bit messy, I'm still learning quite a bit. Thanks!

[MarvinP]

Hi,

This looks like the problem we all go through. It called "What the F is the name of that object"? I normally go to the immediate window and do a debug.print followed by something like userform1.listbox.count and press enter. I normally get an error message until I can figure out what name the object is. "Me" is the object you are in so you might need to add it in front of yoyur LBCities listbox. I did a little tweeking and see the below. I gave up as I didn't find all those hidden sheets in your example. BUT the below seemed to work.

Please Login or Register  to view this content.

[IBahamut]

When I run this code, I am getting a "compile error : method or data member not found" and it highlights the section " If Me.LBCities.Selected(i)" Do you know what might be causing this?

[MarvinP]

I think from that site above you need to put a true in there, like

Please Login or Register  to view this content.

[IBahamut]

Got it! Thanks for all your help!