Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto delete cell content
HI
I have a worksheet wherein at cell C8 i have put a validation as follows in case the value at B8 is more than zero then only any value in the cell C8 can be fed. The same is working , however in case i change the value at cell B8 from any number to zero the values at cell C8 does not get deleted. does any body knows how to tackle this |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto delete cell content
Data|Validation isn't retroactive--if you change the rules, then the existing
value isn't validated. And if you want to actually clear the second cell, you're going to have to use a macro--maybe an event macro like this: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim myCell As Range Set myCell = Me.Range("a1") If Intersect(Target, myCell) Is Nothing Then Exit Sub If IsEmpty(myCell.Value) Then Application.EnableEvents = False me.range("B1").Value = "" Application.EnableEvents = True End If End Sub If you want to try, I had my parent cell as A1 and my child as B1. Rightclick on the worksheet tab that should have this behavior. Select view code and paste this in (adjust those addresses). Then back to excel. wrote: HI I have a worksheet wherein at cell C8 i have put a validation as follows in case the value at B8 is more than zero then only any value in the cell C8 can be fed. The same is working , however in case i change the value at cell B8 from any number to zero the values at cell C8 does not get deleted. does any body knows how to tackle this -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete cell content | Excel Discussion (Misc queries) | |||
Delete Row based off cell content | Excel Discussion (Misc queries) | |||
auto delete characters in cell left of @ sign | Setting up and Configuration of Excel | |||
Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
can't delete a cell content in excel | New Users to Excel |