Error In Assigning A Combobox Value To A Variable value

[Ark68]

This I'm sure is a simple problem to resolve, but it's eluding me.

UserForm1.uf1cbx1_operatorini.Value = sgini

uf1cbx1_operatorini is a combobox with a series of 6 selectable values. If the value does not exist in the list, the user can select "other" from the list prompting them with an input box to enter a value (sgini).
When the code reaches the line above, it breaks with error "Could not set the Value property. Invalid property value."

Is anyone able to suggest what might be a cause of this error? I have been thinking it might have something to do with the fact that the value represented by variable sgini isn't in the rowsource of the combobox. If so, is there a way I can bypass this limitation?

 

[Domenic]

I don't know whether I'll be able to help either, but when the code errors out on that line what value has been assigned to the variable sgini?

 

[Ark68]

Hi Domenic, the value of sigini is what is expected. Basically, what sgini is the initials of the name provided by the user in the uf1lbl1_name textbox (see code in post 8).

With some testing, I discovered that I can succesfully populate the uf1cbx1_operatorini combobox with that erroneous line of code by substituting 'gsini' with "", or any value in the dropdown list, ie "BK" ... one of the 8 available selections from the combobox. Any other value than these results in an error.

I discovered also, that I can populate other comboboxes and textboxes on this userform by assigning them the value of 'sgini'. So clearly, it's an issue specific to the uf1cbx1_operatorini combobox.

Behavior Properties:
Autosize : False
Autotab : False
AutoWordSelect : True
Enabled : True
HideSelection : True
Locked : False
MatchEntry : 0 - fmMatchEntryFirstLetter
MatchRequired : False
MaxLength : 0
SelectionMargin : True
TextAlign : 2 - fmTextAlignCenter

Data Properties:
BoundColumn : 1
ColumnCount : 1
CoulumnHeads : False
ColumnWidths :
ControlSource :
ListRows : 4
ListStyle : 0 - fmListStylePlain
ListWidth : 0 pt
Rowsource :
Text :
TextColumn : -1
TopIndex : -1

 

[Fluff]

What if you try this

UserForm1.uf1cbx1_operatorini.AddItem sgini
UserForm1.uf1cbx1_operatorini.Value = sgini

 

[Domenic]

Basically, what sgini is the initials of the name provided by the user in the uf1lbl1_name textbox

Yes, but what does sgini actual hold when that line errors out?

 

[Ark68]

Brilliant!!
Just what I needed, thank you!!

Thats awesome now to get me to my next challenge.

 

[Fluff]

You're welcome, although I don't understand why it needs that line.

 

[Domenic]

That's interesting, it will only accept a value that exists within its list of items, yet MatchRequired is set to False. Oh well, in any case, Fluff has given you a solution, so that's great.

Cheers!

 

[Domenic]

Actually, I had one other thought. Maybe, while MatchRequired is set to False when you look under the Properties window, it gets set to True when the code runs, maybe within the initialize event. Anyway, just a thought.