Hi

I have a spreadsheet with three columns filled with A - Company B -
Names C - Address approximatly 3000 rows long.

I have a userform with a Combobox on it to select the three fields
using multi columns. When i have made my selection the Combobox only
shows me the Company.

Is it possible the Combobox can show me all three field i have
selected instead of just the first one? Or is there a better way. I
have looked at the List box, the disadvantage being you have to scroll
to your required address.

Thanks in advance

Addy