Need urgent help please - button to run macro

graduate106

Board Regular
Joined
Jul 14, 2011
Messages
90
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
Joined
Mar 11, 2015
Messages
4,239
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:

Forum statistics

Threads
1,077,795
Messages
5,336,373
Members
399,077
Latest member
johnk94

Some videos you may like

This Week's Hot Topics

Top