I have set up a stopwatch in Excel using the code below (Please excuse the code - I am new so have been using various bits of code I have found on the internet)

Public Sub startClock()

Dim start

start = Timer
Do While stopped = False
DoEvents
Worksheets("ALL@1").Range("E3").Value = Int((Timer - start + 0.5) / 60 / 60)
Worksheets("ALL@1").Range("F3").Value = Int((Timer - start + 0.5) / 60)
Worksheets("ALL@1").Range("H3").Value = (Timer - start) Mod 60
Worksheets("ALL@1").Range("I3").Value = (Timer - start + 0.5) - (Int(Timer - start + 0.5))
Loop

End Sub

Private Sub cmdStart1_Click()
startClock
End Sub

Private Sub cmdStop1_Click()
stopped = True
End Sub

What I would like to do is add a "Pause" function.

If anyone could help me with this it would be greatly recieved. Also please bear in mind I am very new to this and may need to put it in very simple terms.

If you are trying to pause the execution of the macro in the middle somewhere then insert a STOP statement on a separate line.