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

Go into design mode in the VBE.
You will need to set your column count to 3, then set the
column widths in this format 50;50;150. The column width
is in points unless otherwise specified.

"Adam" wrote:

> 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
>