software

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

quot;Pastel Hughesquot; wrote:

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


Or you can write specifically in the validation message box something
likequot; IN THIS CELL please enter.....quot; 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: www.excelforum.com/member.php...oamp;userid=33827
View this thread: www.excelforum.com/showthread...hreadid=535964