I have a userform and have comboboxes for station # and station name. Each # has a unique name and vice versa. I would like the user to be able to either select the station # and have the corresponding station name populate in the combobox or the other way around.

I tried a VLookup of the table in my code, but I can't get it to work. I get a type mismatch error.
Here is the code for changing the station #:

Private Sub cboStationNum_Change()
cboStationName.RowSource = Application.VLookup(cboStationNum.Value, ATLCTable, 2)
End Sub

I'd like to know what I'm doing wrong with the VLookup and if you have any better suggestions on how to get the same functionality that's fine too.

Thanks!