Thread
:
Using an action button.
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 1,522
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
...
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
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]