Userform: Set Combobox.Value on "Change" of a different Combobox

[Overlord475]

I am attempting to change the value of Combobox2 when Combobox1 is changed.
Here is what I have.

Sub Combobox1_Change ()

Combobox2.Value = "(Select)"

End Sub

I am returned an error stating:

"Run-Time error '380': Could not set the Value property. Invalid property value."
When I remove the (Select) string and just set the .Value = "" it will run the code but I want to set the value of the combobox to Value not blank ("")

It should be noted that I am using a Userform_Initialize sub which is pre-populating the values of all Comoboxes on the Userform including Comboboxes1 and 2.

[mehmetcik]

I do not get that error.

Private Sub UserForm_Activate()
ComboBox1.Value = "(Select)"
End Sub

[Bernie Deitrick]

You can just set the listindex to the correct value - for example, if "(Select)" is the first value in the list

Private Sub UserForm_Initialize()
'other code here
Me.ComboBox2.List = Array("(Select)", "whatever 1", "whatever 2", "whatever 3", "whatever 4")
End Sub

Private Sub ComboBox1_Change()
Me.ComboBox2.ListIndex = 0
End Sub

[Overlord475]

You can just set the listindex to the correct value - for example, if "(Select)" is the first value in the list

Private Sub UserForm_Initialize()
'other code here
Me.ComboBox2.List = Array("(Select)", "whatever 1", "whatever 2", "whatever 3", "whatever 4")
End Sub

Private Sub ComboBox1_Change()
Me.ComboBox2.ListIndex = 0
End Sub

The "(Select)" value I am pushing into the combobox is not a selection from the drop down array listing.
It is meant as an initial forced value into the box to prompt the user to click it and select from the drop down options.

I am trying to set the value of the box as you would with an Initialize userform sub

Have you set the MatchRequired property of ComboBox2 to True?

Yes, still no luck

[Norie]

Have you set the MatchRequired property of ComboBox2 to True?

[Norie]

I'm not suggesting you set MatchRequired to True, in fact if you have it set to True that's the reason you get the error you describe.

[Overlord475]

It was set to False at the start. I changed it back.