Using a specific range to populate a list/combo box

  • Thread starter Thread starter tanktata
  • Start date Start date
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
 
Hi tanktata

There is a list property
ListBox1.List = Sheets("Sheet1").Range("D1:D20").Value
 
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
 
Back
Top