Delete Cell Value Based on Another Cell T or F

D

DocuMike

I have cell A1 for instance that's always TRUE or FALSE from a Check Box. If
the value of cell A1 is FALSE, I want it to delete any data that's in cell
A3, or if it's TRUE to leave cell A3 as is. It should be easy but for some
reason I'm hung up on it...thanks
 
D

Dave O

Does A3 contain a formula? If it does, you can use an IF() function.
Suppose the formula in A3 is =B5*B6
You could write an IF() in A3:
=IF(A1=True,B5*B6,"")
 
D

DocuMike

No, A3 is simply a number input from the user. It can be anything greater
than 0. If A1 is FALSE I want any data in A3 to be deleted or A3 set to
blank.
 
J

JE McGimpsey

One way:

Attach this macro to your Forms toolbar checkbox (or call it from your
ActiveX/Control Toolbox checkbox's Click event):

Public Sub Checkbox1_Click()
If Range("A1").Value = False Then _
Range("A3").ClearContents
End Sub
 
Top