+ Reply to Thread
Results 1 to 2 of 2

Sound in a cell?-get an audio file

  1. #1
    Registered User
    Join Date
    01-20-2005
    Posts
    3

    Sound in a cell?-get an audio file

    Forgive me for the double post, but is there a way to get an audio file, such as a .wav, to trigger in a cell when the value of that single cell changes?

    Thanks,

    ~Sly

  2. #2
    Forum Contributor
    Join Date
    11-16-2004
    Posts
    282
    At least from Excel 2000, sound notes were removed from the application meaning you can't play specific sound files attached to cells. You can play a simple tone (the frequency and duration of the tone depend on your hardware and system software, and vary among computers) with a macro assigned to the worksheet you want the tone to play from when a specific cell value changes:

    Private Sub Worksheet_Change(ByVal Target As Range)
    '***NOTE: Change the cell reference below to your own ***
    Target = ActiveSheet.Range("E23")
    Beep ' Add more Beep statements below if you want multiples
    End Sub

    Hope this helps,
    theDude

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1