返回列表 上一主題 發帖

計算儲存格數值變動的次數?

' 放 sheet 裡面

Private Declare Function sndPlaySound Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long
      
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" Then
    [B1] = Val([B1]) + 1
   
    wav_file = "c:\Windows XP 啟動.wav"
    Call sndPlaySound(wav_file, 1)
End If

End Sub

TOP

若要進階的 play , pause,  stop  

麻煩自己 google

TOP

        靜思自在 : 能幹不幹,不如苦幹實幹。
返回列表 上一主題