I use xl2003. In xl2007, MS introduced the Ribbon. Everything got rearranged.

In xl2003, you'd click on the Data menu, then click on Form.

I don't know where it is in xl2007. But I bet you could find it.

mazu wrote:

Hi Dave,

What do you mean by that "Data|Form (xl2003 menus"
Thanks,

"Dave Peterson" wrote:

Ps. Maybe using Data|Form (xl2003 menus) would be more effective here.

mazu wrote:

Hi Dave,

Thanks for your response.
I am asking the same questions that you are asking.
If you know how to solve this problem that will be great.

"Dave Peterson" wrote:

If the combobox doesn't have anything selected, and you type: QWER
What cell gets that value?

If the combobox does have a value, how would you know what cell got the value?

mazu wrote:

Hi,

I have already populated a combox reffering cells from an excel sheet. Here
is the Code.
With ActiveSheet
MyList(0, 0) = .Range("A1")
MyList(1, 0) = .Range("A2")
MyList(2, 0) = .Range("A3")
MyList(3, 0) = .Range("A4")
End With
ComboBox2.List() = MyList

Now i want to update or change values in excel sheet by typing the values in
combo box. I tried to play with listindex, controlsource but could not make
it.

Anybody has an idea, please let me know.
Thanks,

Mazu

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson