Listbox question

jamielill

Active Member
Joined
Jul 27, 2009
Messages
286
if I wanted to load a range to a list box
column 1 row 1 to column 24 row 24

These values will be variable, what would be the command.

Thanks

Jamie Lill
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

BrianExcel

Well-known Member
Joined
Apr 21, 2010
Messages
958
It depends on what kind of listbox you are using. ActiveX control or did you just go to Data > Validation? if you are using an activeX listbox you can do this, but a Data Validation List has to be limited to one column.

If using ActiveX, the easiest thing to do will be to select the range of data you want to be included. Then name the range. Something like Range1 or something that you'll remember.

Then, insert your listbox from the developer tab, set the column count to 24 (since you have 24 columns you want included), and then type the name you gave to the range into the 'ListFillRange' field. The values should display.

HOWEVER, if at all possible I would highly recommend moving all your data for the list into one column. It makes things much easier. Making a listbox that requires 24 columns is a crazy amount of info to plug into it.

Hope this helps.

B
 

Watch MrExcel Video

Forum statistics

Threads
1,108,993
Messages
5,526,118
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top