VBA LOOP, XL with SOUND OBJECT, once a minute

[srands]

Hi, I have an XL spreadsheet with a sound WAV as an EMBEDDED OBJECT, saved as a Macro.

I have another Macro, to play the WAV after a period of time.

Sub MyMacro()
'Bunch of code here
Application.OnTime Now + TimeValue("00:01:00"), "mysoundmacro"
End Sub

HOW CAN I LOOP THIS vb TO REPEAT THE CYCLE?

SEE SAMPLE FILE

Cheers

Stephan

 

[Andrew Poulsom]

Repeat the OnTime line of code at the end of your mysoundmacro procedure.

 

[srands]

Hi could you quote the edited full sentence, as the way I have written it as suggested, the VB macro just plays the WAV file twice.

What should this macro be to play every minute?

Sub MyMacro()
Application.OnTime Now + TimeValue("00:01:00"), "mysoundmacro"
End Sub

Cheers

Stephan