Why no work? ComboBox1.Value = ComboBox1.Text

[ctbaker]

I have a two column combobox where you select an item from the first column and the value is selected from the second column. I want to also allow people to enter by hand an item into the combobox. So, I was trying something like what is shown in the subject of this message:

ComboBox1.Value = ComboBox1.Text which is executed after the user types in the custom entry. I get the error:

"Could not set the Value property. Invalid property value."

Any ideas?

Thanks!

 

[SkipVought]

Hi,

This might work...

Private Sub ComboBox1_Change()
    ComboBox1.AddItem ComboBox1.Text
End Sub

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ctbaker]

Hi Skip,

Thanks for the help. I tried what you gave me but I am getting a Permission Denied error when I try that option.

It is frustrating that a change from a 1 column combobox to a 2 column combobox (col 1 is Text and col 2 is Value) has turned out to be such a headache in how you handle things in Excel.

Thanks again,
Chad