Comment box drops down too far off page

[TPD]

Hello,...I have a form in which I have created some comment boxes. Th
biggest complaint that I get is regarding the comment box that pops u
from the last line of the form. It drops down too far and they alway
have to scroll to read the entire box. When I edit the comment box i
allows me to move it and stretch it any way I want. The problem is tha
no matter where I pull it to, it still opens at the bottom of the for
and beyond where a scroll is required to read it all. Can someon
please tell me how to force the comment box to open upward over th
middle of the form rather than downward beyond the bottom of it???
Simply draggin it up during the edit mode is not working!

Thanks!!

 

[Dave Peterson]

I don't know how to keep them from moving, but you could run a macro to move
them back to where they belong.

From Debra Dalgleish's site:
http://www.contextures.com/xlcomments03.html#Reset

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm