| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command button to clear inputs
Thanks for all the tips! I got it to work.
"Ron de Bruin" wrote: Typo Alert Selction.ClearContents Selection.ClearContents For the OP If you select the cells you want to clear with the CTRL key down you can give the cells a name with Ctrl-F3. After that you can use Range("YourRangeName").ClearContents -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You need to supply some more details to get anything other than a few guesses. What "inputs" need to be cleared and when? Sub Clearit() Selction.ClearContents End Sub Will clear all data from the selected cells. The Delete key will do the same thing. Why do you think you need a macro? Gord Dibben MS Excel MVP On Mon, 2 Apr 2007 12:36:04 -0700, mbing916 wrote: Could you help me with the macro so I could assign a button to clear inputs? Is there a place to go to look up different macros? I don't have much experience with this and it is hard to know what to put so the macro will work. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Button | Excel Discussion (Misc queries) | |||
| excel command to clear contents except 2 formulas | Excel Discussion (Misc queries) | |||
| How do i clear a cell using a command button? | Excel Discussion (Misc queries) | |||
| create a clear button | Excel Discussion (Misc queries) | |||
| Button to clear all entries? | Excel Worksheet Functions | |||
Threaded Mode
