BuddyB
Nov 12th, 1999, 12:18 AM
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
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