Variable length of input area in a combobox
 

Hi

I have a combobox from the toolbar "formula auditing"(my excel is
danish, but i think this is the english expression). Now the input
area for this combobox i variable in length, which means that some
times it will be 8 cells and other times eg. 11 cells.

Any idea how I can get a variable input area for the combobox?

I have tried using =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A,1) in a
cell and then naming the cell to "lists" and use the name "lists" in
the input area, but this only shows one cell and not the whole row.


Any ideas?

Variable length of input area in a combobox
 

I'm not sure why you included that 1 inside the =counta() expression. Maybe a
typo in the post???

Debra Dalgleish has some notes here that may help:
http://contextures.com/xlNames01.html#Dynamic

Kasper wrote:

Hi

I have a combobox from the toolbar "formula auditing"(my excel is
danish, but i think this is the english expression). Now the input
area for this combobox i variable in length, which means that some
times it will be 8 cells and other times eg. 11 cells.

Any idea how I can get a variable input area for the combobox?

I have tried using =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A,1) in a
cell and then naming the cell to "lists" and use the name "lists" in
the input area, but this only shows one cell and not the whole row.

Any ideas?

--

Dave Peterson