Erasing cells when the validation dropdown choice changes
Can be done, but how do D16 and D17 get filled to start with?
Once cleared, what's to clear if another choice is made from the DV
dropdown?
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("D11")) Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False
Me.Range("D16:D17").ClearContents
endit:
Application.EnableEvents = True
End Sub
Right-click on the sheet tab and "View Code"
Copy/paste the code into that module.
Alt + q to return to Excel.
Gord Dibben MS Excel MVP
On Tue, 18 Aug 2009 12:51:01 -0700, Bob
wrote:
I have a validation dropdown box in cell D11. Cells D16 and D17 are
"regular" cells. Each time a user selects a different choice in D11, I need
to have the contents in D16 & D17 erased (i.e., revert to being blank cells).
Being relatively new to VBA, I have no idea how to program this. Can anyone
help me?
Thanks,
Bob
|