Adding to a drop down list

  • Thread starter Thread starter ladybug
  • Start date Start date
L

ladybug

I have created a drop down list and it shows up where I need it. I now need
to add entries to that list, sometimes I can and sometimes I can't. I'm not
sure what I've done differently when it works, what is the proper procedure
to add items to a drop down list that is already created?
 
If your drop down list is comming from a range, my guess would be your adding
to the bottom of the range, but your listbox doesn't know that the range has
changed.

Easy way is to make sure you INSERT (row or cells) inside of your existing
range, rather than tacking data onto the bottom.
 
Thank you.

Jonathan Cooper said:
If your drop down list is comming from a range, my guess would be your adding
to the bottom of the range, but your listbox doesn't know that the range has
changed.

Easy way is to make sure you INSERT (row or cells) inside of your existing
range, rather than tacking data onto the bottom.
Click to expand...
 

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

Filtered drop down list 2
How to Update drop-down list? 5
ADD ITEM TO A DROP DOWN LIST? 4
Formatting a drop down list 2
Drop down list and macros? 1
Position of a drop-down list 5
Drop-Down List 3
drop down list based on other drop down list pick 1

Back
Top