Reset Button to clear cell value and not cell formatting

[mikeb7500]

On a form I developed, these cells are formatted with a border, color and a drop-down list. I created a RESET BUTTON to clear these cells, but when you press the reset button it also clears the border, color, and the drop-down list. not just the value in the cell.

What code can I use to JUST to only clear the value back to zero in each cell, which is the first option in my drop-down lists?

Also, I would like this reset button to work in a protected worksheet if possible. Any ideas? Thanks!


Sub Clearcells()
Range("G1").Clear
Range("E3").Clear
Range("C4").Clear
Range("C5").Clear
Range("C5").Clear
Range("D7").Clear
Range("C5").Clear
Range("F6").Clear
Range("G5").Clear
Range("E8").Clear
Range("I9").Clear
End Sub

 

[KennyGreens]

Hi, I believe you are looking for ClearContents. Use as:

Range("G1").ClearContents

 

[Fluff]

How about

Sub Clearcells()
   ActiveSheet.Unprotect "Pword"
   Range("C4:C5,D7,E3,E8,F6,G1,G5,I9").ClearContents
   ActiveSheet.Protect "Pword"
End Sub

 

[mikeb7500]

Thanks worked great!

 

[Fluff]

Glad we could help & thanks for the feedback