I have a form that makes heavy use of cell validation.
When the Office Assistant is active, the validation messages appear next to
the assistant. Some users do not readily associate these messages with the
current cell. When the assistant is not active, the messages appear next to
the current cell, which of course, works much better. What I would like to
do is include some VBA code to test for the presence of the Assistant and
disable it, if it is present.
Does anyone know what this code would be?
Thanks

Do help in VBA window for Assistant

"Pastel Hughes" wrote:

I have a form that makes heavy use of cell validation.
When the Office Assistant is active, the validation messages appear next to
the assistant. Some users do not readily associate these messages with the
current cell. When the assistant is not active, the messages appear next to
the current cell, which of course, works much better. What I would like to
do is include some VBA code to test for the presence of the Assistant and
disable it, if it is present.
Does anyone know what this code would be?
Thanks

Or you can write specifically in the validation message box something
like" IN THIS CELL please enter....." so now the users can be sure the
help refers to the curent cell even though the help message comes from
the help assistant.


--
florinel
------------------------------------------------------------------------
florinel's Profile: http://www.excelforum.com/member.php...o&userid=33827
View this thread: http://www.excelforum.com/showthread...hreadid=535964