Combo Boxes

  • Thread starter Thread starter drofnats
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding database data to a combo box... 1
How to reference cell created from dropdown list in a combo box? 1
combo box 1
How do I enter a list in a Combo box? 6
combo box 2
Combo Box 5
Combo box problem 1
VBA Form Combo Box question. 3

Back
Top