Insert a command Button

[Dustin]

I would like to insert a command button, that when clicked brings a range of
cells (say B4:B19) to equal 0 .

Can some one point me towards a tutorial?

Thank you.

 

[Frank Kabel]

Hi
try the following:
- insert a command button
- use the following code statement
activesheet.range("B4:B19").value=0


As a starting point for macros see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Dustin]

Thank you Frank, It works beautifully!

Hi
try the following:
- insert a command button
- use the following code statement
activesheet.range("B4:B19").value=0


As a starting point for macros see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm