Use the change event for the cell input. something like this
Right click on the sheet-tab name, view code, and enter following
code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
' keep only one line from the following
Range("B1") = False ' if you are using forms menu check
box
CheckBox1.Value = False ' if you are using Control Toolbox menu
check box
End If
End Sub
Where A1 is the input cell, B1 is the cell linked to your check box if
you have the Forms menu checkbox.
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=373897