Need urgent help please - button to run macro

graduate106

Board Regular
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

Well-known Member
Would it not be simpler to reset the value when the macro is run ? First line of macro could be ..
Code:
Range("F10") = 0
 
Last edited:

Some videos you may like

This Week's Hot Topics

Top