Use Excel Table Column in ComboBox Input Range property
- by V7L
I asked this in StackOverflow and was redirected here. Apologies for redundancy.
I have an Excel worksheet with a combo box on Sheet1 that is populated via its Input Range property from a Dynamic Named Range on Sheet2. It works fine and no VBA is required.
My data on Sheet2 is actually in an Excel Table (all data is in the XLS file, no external data sources). For clarity, I wanted to use a structured table reference for the combo box's Input Range, but cannot seem to find a syntax that works, e.g. myTable[[#Data],[myColumn3]]
I cannot find any indications that the combo box WILL accept structured table references, though I cannot see why it wouldn't.
So, two part question: 1. Is is possible to use a table column reference in the combo box input range property (not using VBA) and 2. HOW?
