Audio Queues (sp) in excel 2003

  • Thread starter Thread starter MJB
  • Start date Start date
M

MJB

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top