the below *event procedure* will clear the contents of range c5:c8 when the value of cell in c3 is changed
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$3" Then
Sheets("DATA").Range("C5:C8").ClearContents
End If
End Sub
On Thu, May 28, 2009 at 2:13 PM, Arora, Aman (GE Money)
<[email protected]>wrote:
>
> Hi,
> Please help me in Excel Concept. In given attachment when ever we
> change select in Cell *C3 *( Drop-down ). the Data related to his column
> ( C5:C8 ) automatelly delete by VB. Only want to delete selected data if we
> change values in dropdown.
> Attachment enclosed.
> Regards
> Aman S Arora
>
TEST_aman.xls
Description: MS-Excel spreadsheet
