Display Listbox values

[Macro1]

Hi,

I'm sure this is a simply one, but I was wondering if anybody could tell me the best way to display the value of three seperate listboxes as a string of text in a seperate cell.

So for example:

Listbox1 = London
Listbox2 = House
Listbox3 = SE7

So in cell A1 its says

"London House SE7"

Many thanks in advance

Macro1

[romperstomper]

What kind of listboxes and where are they located?

[Palmetto]

See attached for basic example using listboxes from Forms and Active-X controls.

A Forms Listbox returns an index value to a linked cell, so you will need to do a look up in order to join the text strings.

Basic code for Forms list box (assigned to a button). Linked cells are on row1, look up cells are on row2 and the code writes the string to cell A10.

Please Login or Register  to view this content.

With an Active-X listbox you can directly join the value in the control.

Please Login or Register  to view this content.

[Macro1]

Thanks Guys,

They are Control Toolbox Listboxes located on a worksheet. Palmetto that code worked a treat.

Many Thanks

[Palmetto]

Glad you got the solution you needed.
Please mark this thread as [SOLVED] by going to YOUR first post and clicking on Thread Tools, then Go Advanced and choose the solved prefix.