Alarm function with four different conditions

Hello,

Is there a VBA a code for an alarm function

I have four different conditions,
I want it to play a sound when it reaches 9
then play another sound at 10
then another different from the two when it reaches 11
then another different from the three when it reaches 12
Each with a different sound (wav file)

Instead of separately doing each one. I wanted to minimize the space I have on the workbook. I have this code for each one:

Please Login or Register  to view this content.

Can you help me find a code where I can operate all sounds with one alarm function

Hi, Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)