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 Label1.Caption = ListBox.List(ListBox.ListIndex) would display both "city" and "phone" in the caption...I would like to display just the "city". Thanks.

If the format of the listbox item is "city name XXX-XXX-XXXX" - meaning no spaces in the phone number, you can use the following:

strTest = "San Jose 213-222-1212"
MsgBox Left(strTest, Len(strTest) - InStr(1, StrReverse(strTest), " "))