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

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

F5SpecialConstantsOK

EditCleat Contents.

You could record a macro whilst doing this and attach the macro to a button.


Gord Dibben MS Excel MVP

On Sun, 4 Nov 2007 07:58:01 -0800, 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.

Thank you for your help. Could you help me again? I have 3 more questions.
1. After the cells are cleared, all of the cleared cells remain selected.
How do I modify the macro so that the only first cleared cell is selected
after all the cells are cleared?
2. When the workbook is opened a macro warning appears. Can the warning be
safely eliminated?
3. What is the difference between Sub and Private Sub?
Thank you.
--
dow


"FSt1" wrote:

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