| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i reset the default from "general" to "number" | Excel Discussion (Misc queries) | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
| using % button gives error "percent style not found" Can I reset? | Excel Discussion (Misc queries) | |||
| Clear"Reset" data input. | Excel Worksheet Functions | |||
Hybrid Mode
