I was going this route because of the autocomplete capabilities. I should have mentioned that in my post. Any ideas as to how I can do this would surely be appreciated.
Thanks, Steve On Jun 1, 8:08 am, norie <norie.mace...@tiscali.co.uk> wrote: > 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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
