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.