VBA - clear contents when cell is clicked

[Jasesair]

This should be an easy one - I'm still a bit new to VBA.

When D9 is clicked, I'm wanting whatever is in the cell to be cleared. The cell is actually a searchable data validation list, so I'm wanting the user to be able to see the full list every time they click the little arrow, and not the reduced list based on what has been typed into the cell. Hope that makes sense.

Any help would be very much appreciated.

 

[Gokhan Aycan]

You can use worksheet_selection change event perhaps. Something like:

If not (Intersect(Target,Range("D9")) is Nothing) Then
    Range("D9").Value =""
End If

 

[Jasesair]

Many thanks. That worked well.