Bonjour le forum,
J'ai un trou de mémoire comment on code
"With Combobox1 et la 2, 3 etc ..."
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
With ComboBox1 & ComboBox2
.Enabled = False
.BackColor = RGB(245, 222, 179)
End With
End If
If CheckBox1 = False Then
With ComboBox1 & ComboBox2
.Enabled = True
.BackColor = RGB(255, 255, 255)
End With
End If
End Sub
merci
J'ai un trou de mémoire comment on code
"With Combobox1 et la 2, 3 etc ..."
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
With ComboBox1 & ComboBox2
.Enabled = False
.BackColor = RGB(245, 222, 179)
End With
End If
If CheckBox1 = False Then
With ComboBox1 & ComboBox2
.Enabled = True
.BackColor = RGB(255, 255, 255)
End With
End If
End Sub
merci