Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ResetFields
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ResetFields
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|