Worksheet name = list.NamedRanges
Worksheet Code Name = ShLI01
Combo box name = Namecb1
Combo Box is populated with a dynamic list of the Activeworkbook named ranges.
I wish a list of values for the named range selected in the combo box. The list starts in cell Q8 then proceeds down column Q. Several named ranges have multiple values. This program is in design mode so I wish to use the code name in formulas because worksheets may be renamed for better understanding.
I would appreciate any assistance.