I want to apply a drop down bar to all cells that is linked to a list in a different tab. But when/if someone wants to add something to the list, i want them to just be able to add it and it automatically show up. I know you can just include more cells that are not in the list already but i dont want a huge drop down bar of all blanks.
Thanks!
See later thread where this is being answered.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Make the reference to the DD list dynamic. Something like...
OFFSET($A$1,0,0,COUNTA($A:$A),1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/excel-form...-question.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks