| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Load a ComboBox From a Dynamic Range
Hello,
I want to use a ComboBox on Sheet1 that uses a list of Customers on Sheet2 for its data source. The Customer list is currently 188 names long and growing (Ranges D18:D199). If I use the ListFillRange property the range doesn't adjust as I add new customers to Sheet2 - It simply moves down (D19:D200) ignoring the new addition(s). Is there a way to keep this ComboBox dynamic? -- Regards... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NUMBER OF ROWS IN A DYNAMIC RANGE | Excel Worksheet Functions | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Chart attached to dynamic range | Charts and Charting in Excel | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions | |||
Threaded Mode
