| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a cell value when another cell changes
How do I change the value of a cell when another cell changes?
In other words, if the value of cell D12 changes I want the value in cell E12 to be deleted. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change a cell value when another cell changes
In worksheet code:
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("D12"), Target) Is Nothing Then Else Range("E12").Clear End If End Sub -- Gary's Student "wahamler" wrote: How do I change the value of a cell when another cell changes? In other words, if the value of cell D12 changes I want the value in cell E12 to be deleted. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change a cell value when another cell changes
If you know what the value in D12 is, you could use a formula in E12 to
display blank if D12 is not that pre-defined value. example - if the value in D12 is 5 and the value in E12 is also 5 (but can be whatever you want): =IF(D12<5,"",5) HTH, Paul "wahamler" wrote in message ... How do I change the value of a cell when another cell changes? In other words, if the value of cell D12 changes I want the value in cell E12 to be deleted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Using DTPicker to change date in a cell when user selects cell? | Excel Programming | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
| How do I change the color of a cell depending on the result of the function in that cell | Excel Programming | |||
| Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency | Excel Programming | |||
Linear Mode
