Shortcut #6: Referring To A Named VBA Range. As explained above, when referring to a VBA Range that has a name, you replace the address of the range with the relevant name. Therefore, the basic syntax is “Range(“RangeName”)”. When using square brackets, the logic is the same.
Excel Listfillrange
I am trying to use 2 different Listfill Ranges in a combo box depending onwhether a check box is true or false. The code blows up on the last line ofcode ComboBoxDept.ListFillRange = NewFillRange.
Can anyone help me figureout what I'm doing wrong?Dim NewFillRange As RangeIf CheckBoxEntity.Value = True Then Set NewFillRange =Worksheets('Demo').Range('DemoDeptByEntity')If CheckBoxEntity.Value = False Then Set NewFillRange =Worksheets('Demo').Range('DemoDept')ComboBoxDept.ListFillRange = NewFillRange.