View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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