Combo Box List Referencing

**Gus80** · 05-21-2008, 09:19 PM

Hi Everyone

Is there any way to reference a list for a combo box through a cell reference typed in a cell?

example:
List for Combo Box contained in range A1:B10
Cell C1 contains text "$A$1:$B$10"
Combo box referencing C1 which in turn references $A$1:$B$10

The more I look at this, the less possible it looks

Any help would be greatly appreciated.

Thanks

Mark

**Andy Pope** · 05-22-2008, 05:25 AM

You would need to add a named range which used the INDIRECT formula

So with data in A1:B10 and description of range in C1 you could create a name
COMBO_LIST which used the formula =INDIRECT(Sheet1!$C$1)

The set the ListFillRange to COMBO_LIST

make sure to set ColumnCount to 2