Excel Macro Help

[Neverland]

Hi,

I was wondering if someone could help me out. I have an excel macro which is a clock/timer. The only problem is that whenever I change any cell in the spreadsheet, it seems to stop the clock.

I am looking to introduce a solver which runs continuously, while leaving the clock running at the same time. Would it be better to use the solver or to create an iteration based macro?

Does anyone have any idea how I'd code it? Im not the most experienced at this type of thing!

Thanks a lot

 

[VoG]

Can you post your clock code.

 

[Neverland]

I just got this from a website, copied and pasted, and it worked.


Sub stopwatch()
'Seconds and fractions of seconds Timer!
Dim Start, Finish, TotalTime

'Set timer.
Start = Timer
StopSW = False
ReSetSW = False
myTime = Sheets("Controls").Range("AA1").Value
Sheets("Controls").Range("e12").Select

myStart:
'Yield to other processes.
DoEvents
'Calculate time.
Finish = Timer
TotalTime = Finish - Start
'Show time on sheet!
Sheets("Controls").Range("e12").Value = Format(myTime + TotalTime, "0")
'Test for "ReSet or Stop!"
If ReSetSW = True Then
Sheets("Controls").Range("e17").Value = 0
Sheets("Controls").Range("AA1").Value = 0
StopSW = True
End If
If Not StopSW = True Then
Sheets("Controls").Range("AA1").Value = TotalTime
GoTo myStart
End If
End
End Sub



Im looking to run that clock while solving an equation which changes cells A10, A11, A12 until B1 reaches its minimum value.