chrisgarcia78
New Member
- Joined
- Jun 15, 2024
- Messages
- 24
- Office Version
- 2021
- Platform
- Windows
Hello, I have the following sheet code to pronounce a sentence if a condition is met however I have an excel Query that refreshes data every 2 minutes so every two minutes the sentence is pronounced and I would like that to happen only when the number the cell changes to 1 one time.
Private Sub Worksheet_Calculate()
If Range("A1").Value = 1 Then
Application.Speech.Speak "Congratulation!! You reached your goal!"
End If
End Sub
Private Sub Worksheet_Calculate()
If Range("A1").Value = 1 Then
Application.Speech.Speak "Congratulation!! You reached your goal!"
End If
End Sub