Using FORMS toobar, select Button and assign macro "RESET" (see below):

Sub Reset()
Selection.ClearContents
End Sub


Highlight fields to be reset and click RESET. If you want to be very
specific about SELECTION, change to a range:

Sub Reset()
Range("A2:D4").ClearContents
End Sub

HTH

"kyoshirou" wrote:

can i have a button called "Reset"
upon clicked on Reset, all the data fill in all the cells will be reset to
blank.

A B C D
1 2 3 4 Reset

become this:
A B C D



Thanks!