Combo Boxes

D

drofnats

I have a list of people that is currently linked to a
combo box. I was wondering if it were possible to have
the combo box range change automatically with new entries
or deletions. For example:

ListFillRange = table!A1:A10
Now if I add 3 people:
ListFillRange = table!A1:A13

Wondering if there was a better way than just putting in
extra rows in the range, which leaves blank rows in the
combo box. Is this possible? Thanks.
 
P

papou

Use a dynamic name to refer to your data using OFFSET and COUNTA functions:
"=OFFSET(Table!A1,,,COUNTA(Table!A:A))"
and use this name in you ListFillRange Property

HTH
Cordially
Pascal
 
Top