Insert a command Button
 

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.

Insert a command Button
 

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


--
Regards
Frank Kabel
Frankfurt, Germany


Dustin wrote:
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.

Insert a command Button
 

Thank you Frank, It works beautifully!


"Frank Kabel" wrote in message
...
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


--
Regards
Frank Kabel
Frankfurt, Germany


Dustin wrote:
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.