Steve Why not just use Data>Validation... with the List option?
On May 31, 7:49 pm, Steve <sspatri...@yahoo.com> wrote: > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
