Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Load Combo Box with Named Range
I have a named range "SNList" on worksheet "SN List". The named range
consists of two columns and 30 rows. I want to fill a combobox (named "CMB_SN_List") using the contents of the named range. The combobox is set up with two columns. The combobox is on worksheet "Weekly Data". What is the proper syntax for that? I have tried things like: Worksheets("Weekly Data").OLEObjects("CMB_SN_List").ListFillRange = Worksheets("SN List").Range("SNList") but that generates an error. Do I have to use the .AddItem method since I have more than one column? Thanks, Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Combo Box ListFillRange = Worksheet Named Range | Excel Programming | |||
Combo Box Load Above Control? | Excel Programming | |||
Delete from named range based on Combo Box selection | Excel Programming | |||
combo box named range | Excel Discussion (Misc queries) | |||
Excel 97 VBA: Binding a combo to a named range | Excel Programming |