$$Excel-Macros$$ Re: Combo box macro

2009-06-04 Thread Hemant
Hi dear Steve, This is the solution :) Create: 1) A combobox "ComboBox1" 2) A Command Button "CommandButton1" and copy the following code -- Dim x As

$$Excel-Macros$$ Re: Combo box macro

2009-06-01 Thread Steve
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 wrote: > Steve > > Why not just use Data>Validation... with the List option? > > On

$$Excel-Macros$$ Re: Combo box macro

2009-06-01 Thread norie
Steve Why not just use Data>Validation... with the List option? On May 31, 7:49 pm, Steve 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