Apart from actually iterating the list, you can do things like --

TestString = "|" & cboListBox.Value  & "|"
If instr("|Toronto|Mississauga|Hamilton|", TestString) > 0 then ...

(The |s around the string are so you don't get false hits on substrings.)
This is rather ugly programming though, and hard to maintain if the list is
long. Simpler is to set up a list and simply iterate it.

Simpler still, in this case, is to set up the provinces as part of the
original listbox: set it up as a two-column list (town, province), then set
the width of the province column to zero.

Hi Suzanne,

This might be a situation where the Select Case statement would be useful:

Select Case cboListBox.Value
   Case "Toronto", "Mississauga", "Hamilton"
       cboProvince = "Ontario"
   Case "Fairfax", "Falls Church", "Springfield"
       cboProvince = "Virginia"
   Case Else
       cboProvince = "No province selected."
End Select

HTH,
Dave

Hi,

there is no a way other than
comparing each item in the one list
against each item in the other list.

Implementations may vary to a great deal,
as Jezebel and Dave have shown.