VB ListBox error...please help

When I try to display the text selected from a ListBox onto the caption of a label, I get the "Compile error: Argument not optional". Below is the code I'm using, please help:


Private Sub ListBox2_Click()

Label17.Caption = ListBox2.Selected

End Sub

small syntactical error... try this



A ListBox's selected item is designated by a zero-based array index, that's the argument that is missing

The above code displays "true" in the label caption NOT the actual text of what is selected in the listbox. How can I get it to display the actual text of what is selected...

for example, in my list box i have the following cities displayed:

chicago
new york
boston

when a person clicks on chicago, i would like the label caption to display chicago.

Thanks for all the help.

My bad.. a few Tgiving beers and my mind doesn't work anymore... it should be this instead...

Another question related to that:

In my listbox, I'm displaying multiple rows of the following [it's the result of a query sent to Oracle]:

ListBox.AddItem rs("city") & (" ") & rs("phone")

When the user clicks on the ListBox, I would like to have just "city" (not "phone") of that particular selected entry displayed on Label1.Caption. How can I do that? Please help. Thanks.

P.S. Label1.Caption = ListBox.Text OR Label17.Caption = ListBox2.List(ListBox2.ListIndex) would display both "city" and "phone" in the caption...I would like to display just the "city".

Hello VB_Oracle. The code I sent to you earlier had the MyString variable dimmed as a string. That was wrong. Try Dim MyString as variant. Since the split function returns an array. The only problem with that bit of Code is if the city was a two word city like "Fort Lauderdale" then only Fort will be in the label1.caption.