Thread: Clear contents of cell if clicked, then repopulate if nothing is entered
View Single Post
  #1 (permalink)  
Old 01-18-10, 19:14
soadokdls soadokdls is offline
Registered User
  
Join Date: Jan 2010
Posts: 3
Question Clear contents of cell if clicked, then repopulate if nothing is entered
So right now I have the following:

If Target.Address = "$Q$65:$T$65" Then
Selection.ClearContents

Which works fine. But I want something that will repopulate that range with "Type member # here" if they navigate away from that cell without entering anything. Any ideas?

Thanks,
Diana
Reply With Quote