Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question about the ControlSource of a ComboBox
I have a column 'A' in my excel worksheet with the header 'Names' that
lists the names of all the people in a company (one name on each row). Eg. A2 contains the data 'Bill', A3 contains 'Sal', A4 has 'Kim' etc... If I want a ComboBox to display all of these names I figured I could modify the ControlSource property of the ComboBox by changing it to something like 'Sheet1!A2' but that only adds the name in cell A2 to the ComboBox. Is there any way to add the whole list of names to the ComboBox? Note: the list of names keeps changing dynamically so I can't do something like 'Sheet1!A2-A50' Is there a way to reference the entire column? Thanks for any help --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox Question | Excel Discussion (Misc queries) | |||
ComboBox Question | Excel Worksheet Functions | |||
combobox Question | Excel Discussion (Misc queries) | |||
ComboBox Question | Excel Programming | |||
Basic Userform Controlsource question | Excel Programming |