VBA to trigger a sound alert? Hi, I need to identify sales targets over a a larg

Question

VBA to trigger a sound alert?

Hi,

I need to identify sales targets over a a large number of both worksheets and workbooks.

I'm using conditional formatting (yellow fill/bold font) to flag the particular items that are within the range of the criteria but, in order to save time locating these individual items among very large data sets I'm wondering whether an auto_open subroutine which would trigger a warning sound if any of theses items which met the conditions I've set up have been found on any of the worksheets (there could be 100 or more worksheets within the workbook in some cases) and an ever increasing number of workbooks - at the moment, also about 100 workbooks

The above would allow me to simply open a workbook and then check for the conditionally formatted cell(s) only if a warning alert sounded - otherwise I would simply close it without having to scan through all the worksheets in the book and simply open the next to speed up the searches.

Any ideas welcome!

Many thanks!!

Explanation / Answer

Hi..

Perhaps your Open Event macro could call something like:

Sub WarnMe()
Application.Speech.Speak "good morning james"
If Range("A1").Value > 100 Then.
    Application.Speech.Speak "Cell A1 exceeds 100".
Else
    Application.Speech.Speak "all is well".
End If
End Sub

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.