| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) | |||
| count check boxes | Excel Worksheet Functions | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Auto spell check as in word | Excel Discussion (Misc queries) | |||
| Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Threaded Mode
