Textbox vs Combobox

[Surisuki]

I have 1 combobox, with 3 values: Unmarried, Married, Divorced.

If we select the value Unmarried, Divorced, the textbox will be locked and cannot enter data. Only allow data entry if the value “married” is selected.

Can you guys help me with how to write the code?

 

[6StringJazzer]

Is the combobox ActiveX or Forms? Is it on a worksheet or UserForm?

For ActiveX controls on a worksheet or UserForm:

Private Sub ComboBox1_Change()

   TextBox1.Enabled = (ComboBox1.Value = "Married")

End Sub

 

[Surisuki]

Is the combobox ActiveX or Forms? Is it on a worksheet or UserForm?

For ActiveX controls on a worksheet or UserForm:

Private Sub ComboBox1_Change()

   TextBox1.Enabled = (ComboBox1.Value = "Married")

End Sub

On UserForm

 

[Surisuki]

Trên UserForm

Combobox is Forms, please