I would like to add a button (Clear). I would like to make it clear out
input into certain cells to refresh the cel back to zero, awaiting next
input.

Also would like to also do this for a complete document. the clear
button would erase the users input data so as to start completely fresh
with new information on the form.

JudyP


--
JudyP
------------------------------------------------------------------------
JudyP's Profile: http://www.excelforum.com/member.php...o&userid=37137
View this thread: http://www.excelforum.com/showthread...hreadid=568664

Judy

You say "certain cells".

Will these always be the same cells?

If so, create a named range and select that name from the name box and
EditClear Contents.

Or ToolsCustomiseCommandsEdit. Drag the "Clear Contents" button to your
Toolbar.

Or record a macro while doing this and assign the macro to a button. Can save a
couple of key strokes.

If cells will change all the time........look at the EditGo
ToSpecialConstants. Uncheck the types you wish to keep and OK.

EditClear Contents.

For a complete workbook you would have to do each sheet individually by hand as
above or use a macro to go through the sheets.


Gord Dibben MS Excel MVP


On Sat, 5 Aug 2006 14:39:45 -0400, JudyP
wrote:


I would like to add a button (Clear). I would like to make it clear out
input into certain cells to refresh the cel back to zero, awaiting next
input.

Also would like to also do this for a complete document. the clear
button would erase the users input data so as to start completely fresh
with new information on the form.

JudyP

Hi JudyP,

See how you get on with recording a macro

Tools Macro Record new macro

Macro1 Select store in this workbook, then OK

Click the cells you want to clear, then press the Delete key

Stop marco recording

Now - View Toolbars Forms

Click on the "button" icon and draw one on your spreadsheet (Button 1,
you can change this to "Clear"), the Assign macro box opens – select
Macro1 OK

Is this any help?

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=568664