Prev: How do I filter the cells based in Fill color?
Next: Vlookup with corresponding two data (blank and non blnk)
From: Jacob Skaria on 28 Apr 2010 07:45
Try the below..

Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the
right blank portion. Get back to to workbook and try out.


Dim varData As Variant
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
If varData <> "" And varData <> Target.Value Then
Target.Offset(, 2).ClearContents
End If
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
varData = Target.Value
End Sub

--
Jacob (MVP - Excel)


"Dan Wood" wrote:

> I do have another question though.
>
> Is there a way to automatically clear the colum 'E' if something in colom
> 'C' is changed?
From: Reg on 28 Apr 2010 09:29
nice !


"Jacob Skaria" wrote:

> Try the below..
>
> Select the sheet tab which you want to work with. Right click the sheet tab
> and click on 'View Code'. This will launch VBE. Paste the below code to the
> right blank portion. Get back to to workbook and try out.
>
>
> Dim varData As Variant
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Column = 3 Then
> If varData <> "" And varData <> Target.Value Then
> Target.Offset(, 2).ClearContents
> End If
> End If
> End Sub
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> varData = Target.Value
> End Sub
>
> --
> Jacob (MVP - Excel)
>
>
> "Dan Wood" wrote:
>
> > I do have another question though.
> >
> > Is there a way to automatically clear the colum 'E' if something in colom
> > 'C' is changed?
First  |  Prev  | 
Pages: 1 2 3 4
Prev: How do I filter the cells based in Fill color?
Next: Vlookup with corresponding two data (blank and non blnk)