List Boxes

[Robert Pollock]

Hi, thanks for looking at my question.

I have created a list box on 'sheet2' that displays data
from 'sheet1' (sheet1 by the way is named 'MAIN'), however
I cannot get it to show more than one column. I have in
the "Input Range" the following;

"MAIN!$B$16:$B$39" and I do not have anything in the "Cell
Link" field.

I want to display rows 16 to 39, but for columns B,C, and
D.

Thanks
Robert

 

[Mike]

Don't use the Forms toolbar listbox, you can't set muliple
columns with this control. You need to use the Listbox
found in the Control Toolbox on the Visual Basic Toolbar.
Once you've added the VB Listbox, right-click, select
properites, set the ColumnCount property to 3 and use MAIN!
$B$16:$D$39 as the ListFill range (you have to manually
type the range in, there is no range picker).

 

[Pieter Kuyck]

Robert

You have used a Listbox form the Forms
When you use a listbox form the control toolbox than it is possible to have more than 1 column in a listbox

Pieter


| Hi, thanks for looking at my question.
|
| I have created a list box on 'sheet2' that displays data
| from 'sheet1' (sheet1 by the way is named 'MAIN'), however
| I cannot get it to show more than one column. I have in
| the "Input Range" the following;
|
| "MAIN!$B$16:$B$39" and I do not have anything in the "Cell
| Link" field.
|
| I want to display rows 16 to 39, but for columns B,C, and
| D.
|
| Thanks
| Robert
|