Using a specific range to populate a list/combo box

T

tanktata

I know this is probably really easy to do, but how do you populate
list or combo box with data from an existing range, without having t
add each individual item?

Thanks
 
R

Ron de Bruin

Hi tanktata

There is a list property
ListBox1.List = Sheets("Sheet1").Range("D1:D20").Value
 
B

btadams

If you're using controls from the Control Toolbox, select the control o
the spreadsheet then click on the Properties button on the Contro
Toolbox. Then change the ListFillRange property to WorksheetName!Rang
(such as Sheet2!A1:A100). You can leave off the ws name if the range o
cells is on the same worksheet as the contro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top