Audio Queues (sp) in excel 2003
In a standard VBA module, enter this single line:
Public i As Integer
In the worksheet code area, enter the following event macro:
Private Sub Worksheet_Change(ByVal Target As Range)
i = i + 1
If i = 2 Then
i = 0
Application.Speech.Speak "two entries made"
End If
End Sub
--
Gary''s Student - gsnu200777
"MJB" wrote:
Is it possible to get excel to give audio messages after every 2 entries.
|