DB73
Board Regular
- Joined
- Jun 7, 2022
- Messages
- 102
- Office Version
- 365
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
- Mobile
- Web
Hi all,
Maybe stupid question, but why is this not working
cant the combobox read the value as text ??
thanks in advance
Maybe stupid question, but why is this not working
cant the combobox read the value as text ??
thanks in advance
VBA Code:
Private Sub ComboBox2_Change()
If (ComboBox2.value = "alleen rit registratie") Then
'werklocatie
ComboBox3.Enabled = False
ComboBox3.value = "-"
ComboBox3.BackColor = RGB(210, 210, 210)
'BTW verlegd ja/nee
ComboBox9.Enabled = False
ComboBox9.value = "-"
ComboBox9.BackColor = RGB(210, 210, 210)
Else
'project
ComboBox3.Enabled = True
ComboBox3.value = ""
ComboBox3.BackColor = RGB(255, 255, 255)
'BTW verlegd ja/nee
ComboBox9.Enabled = True
ComboBox9.value = ""
ComboBox9.BackColor = RGB(255, 255, 255)
End If
End Sub