Use Excel Table Column in ComboBox Input Range property
Posted
by
V7L
on Super User
See other posts from Super User
or by V7L
Published on 2012-06-01T16:36:03Z
Indexed on
2012/06/01
16:43 UTC
Read the original article
Hit count: 260
microsoft-excel
|tables
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?
© Super User or respective owner