Is it possible to get excel to give audio messages after every 2 entries.

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.

Hey Gary"s........!
I don't know enough about Office to know what you're describing- "VBA module"
event macro- they sound really cool but I'm an old gut that uses excel and
word somewhat but am totally lost otherwise-
Thanks
Mike

"Gary''s Student" wrote:

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.