| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
named range
hi,
i have the following to set the listfillrange of a combobox (forms combobox). but it is not working: Sheets("template").ComboBox1.Range ("num_dropdown") any ideas? thanks in advance, geebee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
named range
hi
is the forms combo box on the sheet???? if so you wont be able to set it. you would need a sheet combo box from the control tool box. then use this code. Sub setlfr() Dim r As Range Set r = Sheets("sheet2").Range("Num_DropDown") ComboBox1.ListFillRange = r.Address End Sub iis the list fill range on another sheet than the combobox? if so use this ComboBox1.ListFillRange = r.Address(External:=True) post back if i have mis understood. Regards FSt1 "geebee" wrote: hi, i have the following to set the listfillrange of a combobox (forms combobox). but it is not working: Sheets("template").ComboBox1.Range ("num_dropdown") any ideas? thanks in advance, geebee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
named range
oh
forgot to mention. the forms combo box doesn't have a list fill range. it has row source. regards FSt1 "FSt1" wrote: hi is the forms combo box on the sheet???? if so you wont be able to set it. you would need a sheet combo box from the control tool box. then use this code. Sub setlfr() Dim r As Range Set r = Sheets("sheet2").Range("Num_DropDown") ComboBox1.ListFillRange = r.Address End Sub iis the list fill range on another sheet than the combobox? if so use this ComboBox1.ListFillRange = r.Address(External:=True) post back if i have mis understood. Regards FSt1 "geebee" wrote: hi, i have the following to set the listfillrange of a combobox (forms combobox). but it is not working: Sheets("template").ComboBox1.Range ("num_dropdown") any ideas? thanks in advance, geebee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| If any cell in named range = 8 then shade named range | Excel Programming | |||
Linear Mode
