Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Create sounds on selecting cell

  1. #11
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-13 15:41, Chris Davison wrote:
    Mark,

    Are you sure "flower of Scotland" would get past any virus-checking software ?

    Hey, I'm also in favour of a devolved parliament for Geordieland as well. "Fog on the Tyne" by Gazza and Lindesfarm (sp?) could be the anthem. (or that one by Hoddle and Waddle, "Diamond Lights" or whatever it was called.)

    _________________
    [b] Mark O'Brien

    [ This Message was edited by: Mark O'Brien on 2002-03-13 16:06 ]

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston TX
    Posts
    550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create sounds on selecting cell

    This works nice but forces the focus to the OLE object.

    Would like to EMBED an object (MIDI) and play without the user knowing...

    Doable?

  3. #13
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create sounds on selecting cell

    What would trigger the midi to play then?

    Do you want the midi to play when the workbook opens?

  4. #14
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston TX
    Posts
    550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create sounds on selecting cell

    Ivan gave us all a nifty routine to play MIDI's on our HD's.

    The code simply starts playing the MIDI and VBA code continues processing .

    So if you've got nifty graphics on the screen and play a MIDI, the graphics can still be doing their thing while the song is playing.

    With the embedded MIDI, the code presented in this thread transfers contol the to OLE OBJECT and seems to pause the VBA until the object is finished doing its thing.

    Similar to playing the MIDI file style, would be nice to kick off the MIDI and continue processing as normal...

  5. #15
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create sounds on selecting cell

    I'm not really following you. Has Ivan given you code to do what you want? Did he do this recently?

  6. #16
    Board Regular
    Join Date
    Mar 2002
    Location
    Houston TX
    Posts
    550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Create sounds on selecting cell

    I did a search on MIDI and found this thread along with a thread in which IVAN dropped a piece of code that allowed you to play MIDI from a file.

    Rather than start a new thread, I hit this one since it made reference to playing an EMBEDED MIDI (which I prefer to playing from a file).

    For my purposes, I kick off the playing of the MIDI straight from a line of code within a module... No specific event associated with firing the playing that I need.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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