View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.