Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a named range?
Could someone please help? I'm having trouble creating a named range,
and adding that range to a ComboBox. The range that I want to add is horizontal, cells A1:E1, calling it "Test". When I add "Test" to ComboBox by doing ComboBox1.ListFillRange = "Test", it only shows A1 in the dropdown. But when I change the named range to VERTICAL, cells A1:A5, everything works out perfectly. Can you not create horizontal named ranges? Are my ComboBox properties not set right?.... Please help. DK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a named range?
The list fill range must be vertical. If you insist on a horizontal range
you'll have to populate the combobox by a macro. This example code assumes the combobox is on a worksheet. Sub FillCombo() Dim Cell As Range With Worksheets("Sheet1") For Each Cell In .Range("Test") .ComboBox1.AddItem Cell.Value Next End With End Sub The combobox will not remember the list when the sheet is saved and reopened so you'd have to run this when the workbook is opened. Better just to go with a vertical list. -- Jim "dksaluki" wrote in message ... | Could someone please help? I'm having trouble creating a named range, | and adding that range to a ComboBox. The range that I want to add is | horizontal, cells A1:E1, calling it "Test". When I add "Test" to | ComboBox by doing ComboBox1.ListFillRange = "Test", it only shows A1 | in the dropdown. But when I change the named range to VERTICAL, | cells A1:A5, everything works out perfectly. Can you not create | horizontal named ranges? Are my ComboBox properties not set | right?.... | Please help. | | DK | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a named range?
ok, i will try to use vertical list.
i did also try the .AddItem method to add each cell item to the combobox list. I got a "permission denied error"! story of my life! ...BUT that's another problem. thanks. i will use vertical list. dk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel |