LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default can VBA be used to sound a *.wav file on condition(s)?

Hi,
My question is on the subject line...
I have a worksheet which has 10-15 cells with long IF statements as
formulas.
The cell formulas are in the form of (not exactly of course):

=IF(A1=condition1 OR B1=condition2, display"first message", else
if(A1=condition2 AND B1=condition3), display"second message", else display
"third message")
etc.

I need to use my laptops internal speaker to sound an alarm (bip) or call a
*.wav file to play.... "if" any one of the cell value is "changed" because
of the conditions on any one of the cell is changed .

Can this be done via VBA?. I'd appreciate if code samples can be given.

TIA
J_J


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Play Sound File Once when cell value condition id met John 1 Excel Discussion (Misc queries) 4 September 1st 07 04:32 PM
Sound File Johno Excel Worksheet Functions 6 July 15th 07 04:26 PM
Playing a sound file from entry in cell NG99 Excel Discussion (Misc queries) 2 January 31st 07 12:27 AM
Making a sound on condition of textbox damorrison Excel Discussion (Misc queries) 4 September 4th 06 11:41 PM
How do you add sound file to a cell in excel Martin Excel Worksheet Functions 9 May 2nd 05 01:12 AM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"