Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Create sounds on selecting cell

  1. #1
    Guest

    Default

    For Mark O'Brien :-

    When a cell is selected, how do you make it sing the national anthem and how do you set which country's anthem is to be sung?

  2. #2
    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

    ****, I knew I should never have posted that message.

    If you're being serious repost and I'll tell you.
    Here are some materials that you'll need.

    1. Sound Files of selected national anthems (preferably no English or British ones, I suggest a sage selection of "Flower of Scotland", "Oh Canada", "La Marseillaise" and "Advance Australia Fair").

    2. Excel

    3. Some cotton wool

    4. Sticky back plastic

    5. 6 cans of extra strength lager

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mark

    I was going to postthis but i get enough greif from prosters have digs at me past year, poor english and terrible speller and im english! little education see.

    I love Formula one and have designed a league (well a great friend Chris D has for US) we have a little group of us predicting winners just fun, now all friends have fun see,

    Ivan made it poss to have drivers pictures pop up in comments on roll over with code, now i wanted to add Anthems to driver and team, thought would be wicked.... so for each race would be loads,

    drivers x 6, teams x 6 and venue x 1 each race.

    is this possible.... see it about before but like i say i an seriouse and i would use it ..

    .>>>>>>
    1. Sound Files of selected national anthems (preferably no English or British ones, I suggest a sage selection of "Flower of Scotland", "Oh Canada", "La Marseillaise" and "Advance Australia Fair").

    So come on what worng with the English????? UK and USare best friends all ways will, i care not who or where.... only joking mate

    BTW British anthem no such thing each UK nations have own and Eire (Ireland) has its own also.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    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

    I had a feeling that the Formula 1 league had something to do with this. I was following that thread. It's an interesting idea, using the comments like that.

    Anyway, back to the tunes. I suggest you search for midi files, in the interests of keeping the spreadsheet small. (David Coulthard would probably Appreciate "Flower of Scotland" more than "God Save the Queen")

    In Excel, goto Insert|Object, then browse to your sound file of choice. In my example we will be using David Coulthard as an example (it could just as easily have been Michael Schumacher, but definitely not Jensen Button. )

    Select the now midi object and rename it to something like "Scotland". Rename it in the dropdown box thingy that usually tells you what cell is active.

    Then, simply, in the sheets change event stick something like this in:


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Target.Count > 1 Then Exit Sub

    Application.DisplayAlerts = False

    Select Case Target.Value

    Case "David Coulthard"
    Sheets("Sheet1").OLEObjects("Scotland").Verb


    Case Else
    Exit Sub

    End Select

    End Sub


    This should hopefully work out for you. I just installed WinAmp yesterday and this is initiating WinAmp. So I guess if you have an application associated to the file type you're starting then it's going to initiate that application as well. Last week it was just playing the sound files for me, bummer.

  5. #5
    Guest

    Default



    So come on what worng with the English????? UK and USare best friends all ways will, i care not who or where.... only joking mate

    BTW British anthem no such thing each UK nations have own and Eire (Ireland) has its own also.


    What's wrong with the English is that I'm Scottish.

    Actually, some of my best friends are English. No, honest. I also have friends of all sexual orientations and ethnic backgrounds.

    Actually England doesn't really have a national anthem. "God Save the Queen" is actually the British national anthem.

    http://www.guardian.co.uk/Devolution...190958,00.html

    Scotland is torn between "Scotland the Brave" and "Flower of Scotland" and this is one of the pressing matters that the devolved Scottish parliament is trying to figure out.

    I'm also in favour of a devolved English parliament BTW.

    Yay! Politics on MrExcel.Com

    I might as well throw this in, I used to live in London. Teddington/Twickenham area.

  6. #6
    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

    **** this login hack not working for me.

    Yes, that rant was from me.

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Never one to argue

    Teddington/Twickenham is hardly London!!!!

    Brixton / Steatham is know arround the world and is know as london (South London my home)

    Nice code will paly and se if can get some cool results, England is fine county really just has many of its own problems, but Excel has no notice to and such problems and works as well as well all can.

    I look forward to this, will be fun...
    thanks
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mark,

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


  9. #9
    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

    Come now, we all know that the City of London is but 1 square mile of area that holds most the famous places/tourist attractions.

    If it's inside zone 6, it's London.

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No Mark

    London to be london has to be London Postcode TRUE or not/

    Brixton is London South West 2, the high street is SW9 not thta that is Brixton OFFICIALLY its Stockwell that SW9, and Brixton is SW2 only, Brixton is very small, now not so SW9 SW2 and SE5 Loughborough is classed as Brixton.

    Stratham is SW16 and Streatham Hill is South bit of SW2 but its all pointless no postcode ... you cant come in....

    you welcome by all means but Teddington is nice and Twickers is nice... look out the windows, no muggers so must ne a nice day or is that the rain keeping them away?


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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
  •