I'm using the code below on a UserForm with 3 checkboxes to allow the user to check only 1 out of the 3 boxes. The code worked perfectly fine in Excel 2003 and Excel 2007, but now that I've switched to Excel 2010, I'm unable to check any of the 3 boxes. Any help would be very appreciated!
Private Sub CheckBox1_Click()
If MOWForm_Stat.CheckBox1.Value = True Then
MOWForm_Stat.CheckBox1.Value = False
Else
MOWForm_Stat.CheckBox1.Value = True
MOWForm_Stat.CheckBox2.Value = False
MOWForm_Stat.CheckBox3.Value = False
End If
End Sub
Private Sub CheckBox2_Click()
If MOWForm_Stat.CheckBox2.Value = True Then
MOWForm_Stat.CheckBox2.Value = False
Else
MOWForm_Stat.CheckBox2.Value = True
MOWForm_Stat.CheckBox1.Value = False
MOWForm_Stat.CheckBox3.Value = False
End If
End Sub
Private Sub CheckBox3_Click()
If MOWForm_Stat.CheckBox3.Value = True Then
MOWForm_Stat.CheckBox3.Value = False
Else
MOWForm_Stat.CheckBox3.Value = True
MOWForm_Stat.CheckBox1.Value = False
MOWForm_Stat.CheckBox2.Value = False
End If
End Sub
---------- Post added at 10:59 AM ---------- Previous post was at 10:52 AM ----------
It's always great to solve your own thread!
Private Sub CheckBox1_Click()
If MOWForm_Stat.CheckBox1.Value = True Then
MOWForm_Stat.CheckBox2.Value = False
MOWForm_Stat.CheckBox3.Value = False
Else
End If
End Sub
Bookmarks