Play Sound in Excel Automatically Using VBA Macro

Here's the complete macro code:
Option Explicit

Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Private Sub Worksheet_Change(ByVal Target As Range)
Dim highestGST As Long

highestGST = 28

If Range("B2").Value GREATER THAN highestGST Then


End If

End Sub

Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Sub PlaySound()
Dim lastrow As Long, i As Long

lastrow = Application.WorksheetFunction.CountA(Sheet1.Range("B:B"))

MsgBox lastrow

For i = 2 To lastrow
Next i

End Sub

NOTE: Replace GREATER THAN with an angular sign.

[moneymachine]

Always the main man never fails : )
You are like Mike Guring Excel is Fun he never fails either
You both the best in your field

[LAZARSELVA]

Thanks, its works great.

Need to play audio if value changes
How to do?

[Get_Some_Panda]

Wow, this actually worked. Thanks so much! Subscribing.

[TheMuszekOkruszek]

How to play more sounds under more conditions??

[skilldevelopment]

shape perform any action for example, rotate or move with sound.
it is possible?

[stanstrong]

How about VBA code to change left/right audio balance or left and audio volume?

[CletoClips]

I have several macros that run 30-90 seconds. I would like to add a beep when the macro is done running, rather than staring at the screen. Is there a way to do this?

[chrisk.]

Nice and good idea to make some fun...

[aryklanees]

hi sir, is it possible to rename closed workbook sheet name thru vba (same name need to be applied for all wb)

[linaseptiani]

If you move this excel file = you will no longer can play that sound.
Cuz you lost the sound.

Can you make the other way to put this sound inside to excel file, and then you make the script for this sound???

[ramneeksharma]

Sir, I'm unable to understand vba. What's the best way to start from scratch.