Excel Formula

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Guys, im using excel 2003, and want to put a button on a worksheet which will reset a specific set of cells to 0 when pressed. But i have no idea how to do this.

Can anyone help?

Thanks
Fergal

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

You could attach the following code to the button:

Code:

Range("E14").Select
ActiveCell.FormulaR1C1 = "0"

This is inserted between the Private Sub and the End Sub part of the buttons code. Obvuisly cahge the cell reference to the cell your wishing to set to zero.

HTH

 

cool. ummmm. how do i create a button?

 

Is it the same cells each time?

Record a macro of you deleting these cells (tools - macros - record macro)

Then enable the forms toolbar, click the button, draw out your button, it shoudl then give you a popup to choose which macro you wish to use.

This saves having to do any programming like mentioned above.