MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drop down lists!!

Posted by Jamal Davis on November 05, 2001 12:40 PM

I am using drop down lists with a linked cell. I want to make around 1,000 -2,000 identical drop down boxes. However, I want each box to have a DIFFERENT cell link (A1, A2, A3, A4, etc). When you copy and paste cell boxes it keeps the same CELL LINK on the properties page for each box. I don't want to have to go in and change each one. Is there a way I can go around this???


Posted by Bob Umlas on November 05, 2001 12:44 PM

Programmatically, after you've created all the dropdown boxes. Manually there's no easy way.

Posted by giacomo on November 05, 2001 12:55 PM

if you right click on the dropdown box the cell link will be in the formula bar. this should save you a couple clicks.