| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Box Code Does Not Work
I have had four suggestions on how to make this work and so far none will work. Now the True Statement has something wrong.
Can anyone help? Private Sub CheckBox1_Click() With CheckBox1 If .Value = True Then ActiveSheet.Range("A2").Value = Range("Sheet2!$B$4").Value Else If .Value = False Then ActiveSheet.Range("A2") = "" End If End If End With End Sub Thank You very much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Box - Macro code | Excel Discussion (Misc queries) | |||
| code to check condition for each row | Excel Discussion (Misc queries) | |||
| Please check my code!!!! | Excel Discussion (Misc queries) | |||
| Check Box Code | Excel Programming | |||
| Check my code to use template? | Excel Programming | |||
Threaded Mode
