On Aug 24, 1:09 pm, "faureman via OfficeKB.com" <u31222@uwe wrote:
I have a sheet that is "monitoring" the status of a another sheet. When the
source sheet changes, the second sheet - named "Error"- displays a message
using a simple "If" statement.

Normally, the monitoring sheet is displaying an empty string (no message)
until the source sheet activates an error condition (0 changes to 1 for error
message activation) within the cells being monitored. When this occurs, a
message is displayed in the error sheet.

Now, I want to activate the speech functionality in "column A" over a fixed
range of cells in the error sheet so the message will be annunciated. How can
I accomplish this?

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200708/1

I have no clue about how efficient this needs to be for you... and I
am not convinced I understand your question 100%..

But if I have a workbook with two worksheets - Data and Error where
cell A1 on the Error worksheet has an error message that is based on
an IF statement checking values in the Data worksheet, I can put code
in the SheetChange macro as follows:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Worksheets("Error").Range("A1").Speak
End Sub

Now, every time you change anything in the workbook, the error message
is read out. That's a good starting point I think?

UKMatt