I'd be interested to know what the problem was as I also have a "display
form at cell location" app (I think totally different approach to Chip's
from memory). It appears to position correctly even with different
row/column sizes, wordwrap, etc, but maybe I have missed something.

Regards,
Peter T


"Steven" wrote in message
...
Chip,

I was working with your Form Position file and trying to incorporate it
into
something I am doing. I have a file that uses:

Private Sub App_SheetBeforeRightClick .....

so that regardless of what file I am in UserForm1 will show on the
RightClick. If the excel file is a basic file with the cells the default
height and width then the form opens in the position like your file. But
if
the file has more going on in it with different row heights and column
widths
and word wrap etc... then the form does not open in the consistent spot as
with the standard file.

Is that to be expected or do I need to do more things?

Thank you,

Steven