View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dustin Dustin is offline
external usenet poster
 
Posts: 7
Default 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.