Results 1 to 3 of 3

Thread: Really need help with this now

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 1999
    Location
    Mililani HI
    Posts
    1

    Post

    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

  2. #2
    Hyperactive Member
    Join Date
    Jul 1999
    Location
    NY, USA
    Posts
    270

    Post

    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
    tyoung@stny.rr.com
    ICQ: 15743470
    AIM: TomY10
    PERL, JavaScript and VB Programmer

  3. #3
    Hyperactive Member Juan Carlos Rey's Avatar
    Join Date
    Aug 1999
    Location
    Mendoza, Argentina
    Posts
    301

    Post

    Where is there your 5 minutes delay?
    Please clarify...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width