Hi, I've managed to get a combo box on a spreadsheet. Now I want to copy that combo box down in column A for a hundred and fifty or more rows and the linked cell to each combo box needs to be the adjacent cell to each combo box in column B. I'll end up using what's in column B later on for a VLOOKUP. Somehow, I think I need a macro that will re- assign the "linked cell" field for each corresponding combo box in column A going down the list. That is, if the combo box is in cell A3, then I need the linked cell field for that combo box to refer to B3. Likewise, for the combo box in cell A4, I need the linked cell field to refer to B4. Any help much appreciated.
Thanks, Steve --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
