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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Load Combo Box with Named Range
Never mind. It's as simple as
..ListFillRange = "SNList" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Load Combo Box with Named Range
You're using the ActiveX combobox, so its
Worksheets("SN List").CMB_SN_List.ListFillRange = "SNList" "EricG" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Load Combo Box with Named Range
Thanks for the reply, Patrick.
One more question - after the user selects whatever from the combbox, I am using ".Visible = false" to hide it. However, its image stays on the screen. If I scroll it out of sight and back in, it's gone, which tells me it is invisible, so the remaining image must be a "ghost". Is there a neat trick to force a screen redraw to get rid of this "ghost" image of the combobox? Thanks, Eric |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Load Combo Box with Named Range
interesting. maybe do the scroll in vba after setting the visible state?
perhaps turning off screen updating to avoid flicker "EricG" wrote in message ... Thanks for the reply, Patrick. One more question - after the user selects whatever from the combbox, I am using ".Visible = false" to hide it. However, its image stays on the screen. If I scroll it out of sight and back in, it's gone, which tells me it is invisible, so the remaining image must be a "ghost". Is there a neat trick to force a screen redraw to get rid of this "ghost" image of the combobox? Thanks, Eric |
Reply |
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 |