Thanks for that, try it like![]()
Select Case LCase(Target.Value) Case "prosurance" Me.CheckBox1.Value = True Me.CheckBox2.Value = True Me.CheckBox3.Value = True Case "care" Me.CheckBox1.Value = True Me.CheckBox2.Value = False Me.CheckBox3.Value = False Case "mi only"
Bookmarks