Thread: Using a specific range to populate a list/combo box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Using a specific range to populate a list/combo box
Hi tanktata

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




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"tanktata " wrote in message ...
I know this is probably really easy to do, but how do you populate a
list or combo box with data from an existing range, without having to
add each individual item?

Thanks.


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote