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.