|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 23rd, 2010, 01:19 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Using an action button.
How do I insert a button into a spreadsheet that will "clear" all values from
cells that are intended for inputting data, but not clear other cells that are not meant for data input? As part of this I suppose I need some way to designate which cells are meant for data input and which ones are not. Thanks, MichaelZ 
|
|
#2
March 23rd, 2010, 01:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an action button.
Simplest way. Hold down the control key while selecting each cell you want
to cleargoto the namebox just to the left of the formula box and type in rngtoclearfire this macro assigned to a shape or forms button. Sub clearcells() Range("rngtoclear").ClearContents End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "MichaelZ" wrote in message news  How do I insert a button into a spreadsheet that will "clear" all values from cells that are intended for inputting data, but not clear other cells that are not meant for data input? As part of this I suppose I need some way to designate which cells are meant for data input and which ones are not. Thanks, MichaelZ
|
|
#3
March 23rd, 2010, 07:12 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an action button.
Ran into a little problem...
Some of the input cells were merged cells, so an error message reading, "Cannot change part of a merged cell" was generated. Is there any way around this? I still want to be able to clear the input cells, even if they are merged cells. Thanks. "Don Guillett" wrote: Simplest way. Hold down the control key while selecting each cell you want to cleargoto the namebox just to the left of the formula box and type in rngtoclearfire this macro assigned to a shape or forms button. Sub clearcells() Range("rngtoclear").ClearContents End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "MichaelZ" wrote in message news How do I insert a button into a spreadsheet that will "clear" all values from cells that are intended for inputting data, but not clear other cells that are not meant for data input? As part of this I suppose I need some way to designate which cells are meant for data input and which ones are not. Thanks, MichaelZ .
|
|
#5
March 24th, 2010, 02:55 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an action button.
Thanks Don. This works great.
Michael "MichaelZ" wrote: How do I insert a button into a spreadsheet that will "clear" all values from cells that are intended for inputting data, but not clear other cells that are not meant for data input? As part of this I suppose I need some way to designate which cells are meant for data input and which ones are not. Thanks, MichaelZ
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
