| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox.ListFillRangeTrouble in VBA
I am trying to use 2 different Listfill Ranges in a combo box depending on
whether a check box is true or false. The code blows up on the last line of code ComboBoxDept.ListFillRange = NewFillRange. Can anyone help me figure out what I'm doing wrong? Dim NewFillRange As Range If CheckBoxEntity.Value = True Then Set NewFillRange = Worksheets("Demo").Range("DemoDeptByEntity") If CheckBoxEntity.Value = False Then Set NewFillRange = Worksheets("Demo").Range("DemoDept") ComboBoxDept.ListFillRange = NewFillRange |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| Combobox items determined by the selection in another combobox | Excel Programming | |||
| Combobox options based on the input of another combobox | Excel Programming | |||
| ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
| How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Threaded Mode
