Making comments appear in the center of the screen.

[Tonso]

i read in an earlier posting that it might be possible to use VBA to
make comments always appear in the center of the screen. i looked at
Debra Dalgleish's site but found no code. Can someone help me with
this?

Thanks,
Tonso

 

[Debra Dalgleish]

I've added code that displays the active cell's comment in the centre of
the visible range:

http://www.contextures.com/xlcomments03.html#Centre

 

[Tonso]

Thanks so very much Debra! Your website has lots of great stuff in it!
Tonso

 

[Debra Dalgleish]

You're welcome! Thanks for letting me know that it helped.

Thanks so very much Debra! Your website has lots of great stuff in it!
Tonso