Excel 2003 - clear button
hi,
drop a command button on the sheet and put code in it similar to this.
Private Sub CommandButton1_Click()
Range("b2,b4,b6,d2,d4,d6").ClearContents
End Sub
you may have to removed my cells and add all of the cells you want to clear
on your sheet.
Regards
FSt1
"dow" wrote:
I am making a spread sheet that will be used as a calculator. Each use
requires numerous entries. Is there a way to make a clear button (or another
method) that will simultaneously clear all of the entries from a previous
use? This spread sheet will also be used on Excel 97.
Thank you.
--
dow
|