| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear value if cell changes
Hi, I have in cell drop down validation in around 8 cells and all are inter
related.. So, when the value of C5 changes, I need the contents in F5, F7 & C7 to the cleared.. and when value of when C8 changes, contents in F8 to the cleared.. Healp pls All the above cell have in-cell drop down validation. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear value if cell changes
Hope this works for you...
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$5" Then Range("F7").ClearContents Range("F5").ClearContents Range("F7").ClearContents End If End Sub -- Tech Whiz Tom MS Access / Excel Applications Analyst "Kashyap" wrote: Hi, I have in cell drop down validation in around 8 cells and all are inter related.. So, when the value of C5 changes, I need the contents in F5, F7 & C7 to the cleared.. and when value of when C8 changes, contents in F8 to the cleared.. Healp pls All the above cell have in-cell drop down validation. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear value if cell changes
Another one:
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If not (intersect(target, me.range("c5") is nothing) then me.range("f5,f7,c7").clearcontents end if if not (intersect(target, me.range("c8") is nothing) then me.range("F8").clearcontents end if End Sub Kashyap wrote: Hi, I have in cell drop down validation in around 8 cells and all are inter related.. So, when the value of C5 changes, I need the contents in F5, F7 & C7 to the cleared.. and when value of when C8 changes, contents in F8 to the cleared.. Healp pls All the above cell have in-cell drop down validation. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear value if cell changes
try somthing this:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$5" Then Range("F7,F5,C7").ClearContents ElseIf Target.Address = "$C$8" Then Range("F8").ClearContents End If End Sub -- jb "Kashyap" wrote: Hi, I have in cell drop down validation in around 8 cells and all are inter related.. So, when the value of C5 changes, I need the contents in F5, F7 & C7 to the cleared.. and when value of when C8 changes, contents in F8 to the cleared.. Healp pls All the above cell have in-cell drop down validation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
| Clear Method not working for a ListBox clear | Excel Programming | |||
| Create a Clear button to clear unprotected cells | Excel Programming | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Type into one cell and automatically clear contents in another cell | Excel Programming | |||
Linear Mode
