I created a button that clears the contents of a cell.
The command in Pivate Sub is:
Me.Range("B12", "B15").clearContents.
What is the command when I want:
1. to clear a selected cell? (same as right click)
2. to clear a selected cell that is validated as list and it also
crears the dependent cell right of it (validated by INDIRECT)
Thank you.
Bart
Bookmarks