Consulting

Results 1 to 6 of 6

Thread: VBA for playing sound effect!

  1. #1
    VBAX Contributor
    Joined
    Nov 2009
    Posts
    114
    Location

    VBA for playing sound effect!

    I want the vba for playing the sound effect. If A1 = B1 , then it will play the sound automatically! Can anyone help? Thanks!

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location

  3. #3
    VBAX Contributor
    Joined
    Nov 2009
    Posts
    114
    Location

    Smile Still don't know how to use it

    I have attached the excel file. If the cell in column C is greater than the cell next to it in column B, then play the sound effect once. What is the script. Thanks!

  4. #4
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

  5. #5
    VBAX Contributor
    Joined
    Nov 2009
    Posts
    114
    Location
    I am a beginner. I don't know how to set the vba for cells also? Can anyone help me to admend the excel file or provide the scripts? Thanks a lot!

  6. #6
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    The Chip Pearson link i gave you gives you all the "script" you need and is well explained!

    Try putting something together and attaching that then we can help get you where you want to be.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

Posting Permissions

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