-
HELP HELP HELP PLEASE
I been pulling my hair out over this little macro lately. I'm very new at VB but trying to
learn. I've got this macro scheduled to run every 5 minutes based on system time. (a
warning message and sound to check a system)
The problem I'm having is that the sound plays and the msgbox work great but when I
either hit the OK button in the msgbox or hit return the wav file and msgbox reappear
this happens over and over and over....
Sub Macro1()
' Macro1 Macro
' Macro recorded 11/8/99
calculate
If Range("N4") <= Now() Then
Range("N4").Select
End If
Call sndPlaySound32("c:\sound.wav",1)
x= msgbox ("message",0 ," Title")
If X = 1 Then end
End Sub
What am I missing???
Thanks
Buddy
-
Sounds like this subroutine is in a timer control. If you want it to stop, set the Timer.Enabled = False
------------------
Tom Young, 14 Year Old
[email protected]
ICQ: 15743470
AIM: TomY10
PERL, JavaScript and VB Programmer
-
Where is there your 5 minutes delay?
Please clarify...
