creating a reset button

[1vagrowr]

I would like to clear values in select cells by pushing a "Reset Values"
button. How can I make one? Thanks for any help on this.

[Max]

Here's a simple example ..

Sample construct at:
http://www.savefile.com/files/3858780
ResetMultiCellRange_1vagrowr_misc.xls

Draw a Command Button from the Control Toolbox* toolbar on the sheet
*Activate it if necessary, via clicking: View > Toolbars > Control Toolbox

Right-click on the button > View Code
Copy > paste the code below into the code window on the right
(clear the defaults first)

Private Sub CommandButton1_Click()
Range("B2,B4,B6,D2,D4,D6").ClearContents
End Sub

Press Alt+Q to exit VBE and return to Excel

Click the "Exit Design Mode" icon** on the Control Toolbox Toolbar
**the one with the "triangle" pic

Test it out. Clicking the button will clear the multi-cell range:
B2,B4,B6,D2,D4,D6

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"1vagrowr" <[email protected]> wrote in message
news:[email protected]...
> I would like to clear values in select cells by pushing a "Reset Values"
> button. How can I make one? Thanks for any help on this.