Combobox & Addresses
 

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

Combobox & Addresses
 

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