I have a quick question about populating a listbox object on a
userform in Excel. I am very used to program Listbox in Access form
and I can see a few differences with Userforms.

I want to populate a Listbox with, say, City names and a numeric
value. Let's say that this number is some kind of index. The list
box
sould show the City names but NOT the associated index value.

Now when I select a city from the Listbox and click the Command
button
I need to read the City's index and not its name. So:

The list box data source is:
3 Melbourne
7 Sydney
13 Adelaide
23 Brisbane

The listbox shows
Melbourne
Sydney
Adelaide
Brisbane

If I click Adelaide and click whatever Command button I need to read
from the list box a property that will return 13.

I have worked out how to populate the list box with an array. So I
use
lstListboxObject.List = aryCityArray()

This populates the Listbox with the names only. I haven't figured
out how to populate with two values per row.

I could also have used:
For i = 1 to <Top Value>
lstListBox.AddItem strCityName
Next i

Even there I tried a few possibilities to find the format for two
values per row. It seems that I need to use a semicolon but I cannot
hide the first column. For example I tried:

For i = 1 to <Top Value>
lstListBox.AddItem intIndex & ";" & strCityName
Next i

Suppose that I set the ColumnCount to 2 the the BoundColumn to 1 or
2. How can I read the bound value for the selected row?

I realise that there a really two different issues here. But they
are related right?