S Oberlander
Board Regular
- Joined
- Nov 25, 2020
- Messages
- 157
- Office Version
- 365
- Platform
- Windows
I have an excel sheet with a combobox and checkbox
the checkbox is set to invoke the combobox and vice versa
somehow after the checkbox is clicked and the combobox value changes thru vba, the combobox stops working
if I click on the combobox, instead of giving me the dropdown selection, the image of the combox momentarily appears duplicated right next to it
see code below, is there any way to fix this?
the checkbox is set to invoke the combobox and vice versa
somehow after the checkbox is clicked and the combobox value changes thru vba, the combobox stops working
if I click on the combobox, instead of giving me the dropdown selection, the image of the combox momentarily appears duplicated right next to it
see code below, is there any way to fix this?
VBA Code:
Private Sub iqmpchck_Click()
If iqmpchck.Value = False Then
ComboBox1.Value = "OFF"
Else
ComboBox1.Value = "Sample"
End If
End Sub
Private Sub ComboBox1_Change()
Dim newval As Range
Set newval = Sheets("Sheet2").Range("B1")
Select Case ComboBox1.Value
Case "Sample"
'things happen
Case "example "
'things happen
End Select
If newval = "OFF" Then
iqmpchck.Value = False
End If
End Sub