Making comments appear in the center of the screen.
 

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

Making comments appear in the center of the screen.
 

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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Making comments appear in the center of the screen.
 

Thanks so very much Debra! Your website has lots of great stuff in it!
Tonso
Debra Dalgleish wrote:
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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Making comments appear in the center of the screen.
 

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

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

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 wrote:

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
Contextures
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html