Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How Do I Install a Reset or Clear Function
I have created an electronic order form and would like to make it reusable.
Is it possible to install a Reset or a Clear button, so the 'quantity' columns will go back to 0? |
#2
|
|||
|
|||
CC, you could use something like this and assign it to a button, or you may
want to save the form as a template, that way when you open it you will have a blank form to start with each time Sub Clear_Column_A() 'Clears column A Columns("A:A").ClearContents End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "CC" wrote in message ... I have created an electronic order form and would like to make it reusable. Is it possible to install a Reset or a Clear button, so the 'quantity' columns will go back to 0? |
#3
|
|||
|
|||
CC
Assume you don't want to lose formulas. CTRL + A(twice in 2003) to select all cells. F5SpecialConstants. Choose what you do or do want to select then OK your way out. Right-clickClear Contents. Record a macro while you do this and assign to a button. Or make it a Template as Paul suggests. Gord Dibben Excel MVP On Tue, 8 Feb 2005 12:01:02 -0800, "CC" wrote: I have created an electronic order form and would like to make it reusable. Is it possible to install a Reset or a Clear button, so the 'quantity' columns will go back to 0? |
#4
|
|||
|
|||
Hey Gord:
This works GREAT...until I Protect the sheet. I have the "Clear Columns" unlocked, and the rest locked. Any suggestions? "Gord Dibben" wrote: CC Assume you don't want to lose formulas. CTRL + A(twice in 2003) to select all cells. F5SpecialConstants. Choose what you do or do want to select then OK your way out. Right-clickClear Contents. Record a macro while you do this and assign to a button. Or make it a Template as Paul suggests. Gord Dibben Excel MVP On Tue, 8 Feb 2005 12:01:02 -0800, "CC" wrote: I have created an electronic order form and would like to make it reusable. Is it possible to install a Reset or a Clear button, so the 'quantity' columns will go back to 0? |
#5
|
|||
|
|||
CC
Which version of Excel do you have that has a "Clear Columns" option when protecting a sheet? 2002 and 2003 do not have this option. In any case, you will have to unprotect the sheet to have F5Special available. You could do the whole thing using a macro if you wish to venture into that. Sub Macro1() ActiveSheet.Unprotect Password:="justme" 'your PWord Cells.Select 'if just want one column use Columns("A:A").Select Selection.SpecialCells(xlCellTypeConstants, 1).Select Selection.ClearContents ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub This code unprotects the sheet, selects all cells then selects numerics cells only and clears those then re-protects the sheet. Gord On Thu, 10 Feb 2005 10:35:10 -0800, "CC" wrote: Hey Gord: This works GREAT...until I Protect the sheet. I have the "Clear Columns" unlocked, and the rest locked. Any suggestions? "Gord Dibben" wrote: CC Assume you don't want to lose formulas. CTRL + A(twice in 2003) to select all cells. F5SpecialConstants. Choose what you do or do want to select then OK your way out. Right-clickClear Contents. Record a macro while you do this and assign to a button. Or make it a Template as Paul suggests. Gord Dibben Excel MVP On Tue, 8 Feb 2005 12:01:02 -0800, "CC" wrote: I have created an electronic order form and would like to make it reusable. Is it possible to install a Reset or a Clear button, so the 'quantity' columns will go back to 0? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
change function variable prompts?? | Excel Worksheet Functions | |||
need to save values from a function before it changes | Excel Worksheet Functions |