Audio Queues (sp) in excel 2003

G

Gary''s Student

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
 
M

MJB

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
 
Top