View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Text to speech particular cell

Let's put the message in a cell, say D16.

In a standard module insert the follow line:
Public OldVar As Variant

Insert the following event macro in the worksheet code area:

Private Sub Worksheet_Calculate()
If OldVar = Range("B15").Value Then Exit Sub
Range("B16").Speak
OldVar = Range("B15").Value
End Sub


Insert the following macro in the workbook code area:

Private Sub Workbook_Open()
OldVar = Sheets("Sheet1").Range("B15").Value
End Sub


--
Gary''s Student - gsnu200817