Data Validation Audio Alert

Charlie45

Board Regular
Joined
Dec 13, 2003
Messages
225
If I am not looking at the screen when I amd scanning I never know the Data Validation Stop Error has displayed.

I am wanting to get an Audible Alert when the Data Validation Stop Error displays.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
For me in Excel 2003 there is an audible alert. But I don't know if that would be the case for a scanned value.
 

Charlie45

Board Regular
Joined
Dec 13, 2003
Messages
225
Thanks for you reply Andrew,

I am using Office 2007 and I can get the visual alert for Data Validation but not the Audible.

Even if the invalid data is entered by keyboard no audible alert only a visual. The sound works for everything else. I was thinking maybe i had missed something.
 

Charlie45

Board Regular
Joined
Dec 13, 2003
Messages
225
Thanks Andrew,

None of our PCs seem to work. I'll have to do some digging to see what I can find.


Thanks for your quick replies.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,215
Messages
5,594,883
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top