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

  • Thread starter Thread starter Billy
  • Start date Start date
B

Billy

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?
 
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
 
F5>Special>Constants. 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
 
Forgot this part.......................

Record a macro while doing this.

Assign the macro to a button from the Forms Toolbar.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RESET BUTTON 2
How do I limit formula results to positive only? 4
Create a yes no message on a command button on click 0
need help on either doing a loop and counting specific values orusing subtotal function 2
help creating a button 5
Reset Button 4
Reset Button 3
Macro to Reset data input form 5

Back
Top