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???
Befuddled.
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.
