Need urgent help please - button to run macro

[graduate106]

Hi there need some urgent help please to finalise a spreadsheet.

I have a load of data entry boxes and then a button assigned to a macro to do some goal seek type calculations over several tabs and it calculates a resulting figure in the same front sheet in say cell F10.

What i want to do is have the figure in F10 reset to ZERO when people start playing around with the data entry boxes, until they press the button to run the macro. Otherwise the figure in F10 will be wrong based on the data entry boxes (until the macro has been run)

I'm sure this will be dead easy for an expert

Many thanks in advance

 

[Yongle]

Would it not be simpler to reset the value when the macro is run ? First line of macro could be ..

Range("F10") = 0

 

[Giordano Bruno]

Why not use the Worksheet Change event to reset the value?