| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
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 In article , "DocuMike" wrote: 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. "Dave O" wrote: 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,"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| How do I change the value in cell based on a future date | Excel Discussion (Misc queries) | |||
| I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
| I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
Threaded Mode
