Accessibility Validation messages

[ggayathri]

I have the following situation where I seek help, as I am a newbie to Excel programming.

For all input cells , I would like to add accessibility validation messages (i.e. "Enter the phone Number.") and also, would like to add a menu to allow the user to enable/disable these messages. When the accessibility messages are off, the menu item should say something like “Enable Accessibility Messages”. When they are on, it should say something like “Disable Accessibility Messages”. Also, when you open the file, the messages will have to be enabled/disabled, based on the validation flag that was saved with the file.
How can this be achieved? Any help is appreciated. Thanks in advance.

Gayathri

[modytrane]

It's not clear what you are trying to achieve. Please post a sample workbook.
modytrane.

[ggayathri]

Accessibility is for People with Disabilities. So when a person with disability(mainly visual) uses Excel application, he/she tends to use a screen reader like JAWS to read the contents of the Excel application. Hence the question, as how to add something like tool tips to the various input fields which would be read out, so that any user can enter relevant details.

[romperstomper]

Have you tried using Data Validation? It allows you to specify input messages.