| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I clear the contents of one cell from another cell?
I would like to clear the contents of a cell in an Excel worksheet from
another cell in the same worksheet based on the content of that other cell. Stating it in words: if cell A2 equals 1 then set cell A1 equal to "blank". Is there a simple way to do this? I am using cell A1 for input by the user therefore A1 cannot contain an equation. |
|
#2
|
|||
|
|||
|
You could use this VBA code:
Private Sub Worksheet_Change(ByVal Target As Range) If Range("A2").Value = 1 Then Range("A1").Value = "" End Sub "RonB" wrote: I would like to clear the contents of a cell in an Excel worksheet from another cell in the same worksheet based on the content of that other cell. Stating it in words: if cell A2 equals 1 then set cell A1 equal to "blank". Is there a simple way to do this? I am using cell A1 for input by the user therefore A1 cannot contain an equation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
| Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Linear Mode
