View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ailsa02 Ailsa02 is offline
external usenet poster
 
Posts: 2
Default Check box logic question

Gary,

You are soooo the man! Thank you! That worked perfectly!

Ailsa

"Gary Brown" wrote:

Private Sub CheckBox1_Change()
If CheckBox1 = True Then
CheckBox2 = False
End If
End Sub

Private Sub CheckBox2_Change()
If CheckBox2 = True Then
CheckBox1 = False
End If
End Sub

--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Ailsa02" wrote:

How do I create a series of check boxes that when you check the second box,
the first box will automatically uncheck?