View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Erasing cells when the validation dropdown choice changes

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