How do I create a "Reset Data" Button for a Worksheet?
 

I have a spreadsheet for calculating hours worked by plugging numbers into
specific columns and I want to be able to click a button and reset those
numbers to "0". How do I do that?
--
Billy

How do I create a "Reset Data" Button for a Worksheet?
 

Use a macro. Easiest way would be to record yourself zeroing out all the
cells. (Select all cells you want to zero, type "0", press Ctrl+Enter).
Then from the Forms toolbar, create a button and assign your macro to it.

If you want to edit your macro, you can open the VBA editor by pressing
Alt+F11
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Billy" wrote:

I have a spreadsheet for calculating hours worked by plugging numbers into
specific columns and I want to be able to click a button and reset those
numbers to "0". How do I do that?
--
Billy

How do I create a "Reset Data" Button for a Worksheet?
 

F5SpecialConstants. Uncheck all but Numbers and OK

Type 0 in active cell then CTRL + ENTER to add the zero to all selected
cells.


Gord Dibben MS Excel MVP


On Mon, 15 Dec 2008 11:08:04 -0800, Billy
wrote:

I have a spreadsheet for calculating hours worked by plugging numbers into
specific columns and I want to be able to click a button and reset those
numbers to "0". How do I do that?

How do I create a "Reset Data" Button for a Worksheet?
 

Forgot this part.......................

Record a macro while doing this.

Assign the macro to a button from the Forms Toolbar.


Gord

On Mon, 15 Dec 2008 11:40:33 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

F5SpecialConstants. Uncheck all but Numbers and OK

Type 0 in active cell then CTRL + ENTER to add the zero to all selected
cells.


Gord Dibben MS Excel MVP


On Mon, 15 Dec 2008 11:08:04 -0800, Billy
wrote:

I have a spreadsheet for calculating hours worked by plugging numbers into
specific columns and I want to be able to click a button and reset those
numbers to "0". How do I do that?