Disable TextBoxes and "gray it out" Based on ComboBox Choice

[Cyril Beki]

I have two textboxes (TextBox1, TextBox2) that need to be disabled based on combobox1. I need the textbox to be "gray out" to show they are disabled ?How can i do it ?

Private Sub ComboBox1_Change()
If ComboBox1.Value = "Section" Then
TextBox1.Enabled = True
TextBox2.Enabled = False
End If
End Sub

Thank you in advance

 

[DanteAmor]

Try this:

Private Sub ComboBox1_Change()
  If ComboBox1.Value = "Section" Then
    TextBox1.Enabled = True
    TextBox2.Enabled = False
    TextBox2.BackColor = &H8000000F
  End If
End Sub

 

[Cyril Beki]

T

Try this:

Private Sub ComboBox1_Change()
  If ComboBox1.Value = "Section" Then
    TextBox1.Enabled = True
    TextBox2.Enabled = False
    TextBox2.BackColor = &H8000000F
  End If
End Sub

Thank you so much ! It works