Archive of Mr Excel Message Board
Back to Links in Excel archive index
Back to archive home
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.
Re: Drop down lists!!
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.
Re: Drop down lists!!
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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.