ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   reset values in select cells (https://www.excelbanter.com/excel-discussion-misc-queries/60864-reset-values-select-cells.html)

1vagrowr

reset values in select cells
 
I would like to create a "Reset Values" button on a worksheet to clear only
select cells. All suggestions greatly appreciated.

Bob Phillips

reset values in select cells
 
How about tying tis macro to a forms toolbar button

Sub ResetCells()
Selection.Clear
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"1vagrowr" wrote in message
...
I would like to create a "Reset Values" button on a worksheet to clear

only
select cells. All suggestions greatly appreciated.





All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com