Programmatically change the font size of Comments

[chrismann85]

Hi All,

Is there a way to programatically to first of all select all comments, show comments, and then change the font. The reason I ask is that at 50% zoom, you cannot read the comments of font size 8.

Does anyone have any suggestions.

---

Thanks in advance

Chris

[chrismann85]

Just so that you know, I have tried setting the defaults for Tooltip in the Display options but I only want the changes to be made for Excel. Also it didn't seem to change the font for existing comments, only new comments.

[royUK]

Try

Please Login or Register  to view this content.

[chrismann85]

Thats fantastic Roy, I can always rely on you.

Thanks

But is there a way to resize the comment box to fit the new larger text?

[dominicb]

Good afternoon chrismann85

Just add this line after royUK's End With line :

Please Login or Register  to view this content.

HTH

DominicB

[chrismann85]

That worked great, thanks for all the help.


Chris

[jpachoulli]

I myself am very new to programming in Excel, although I've used Excel for many years pretty much as a passive side end-user. Lately I've been parusing the forums and finding a lot of great information like these bits of code for resizing the comments.

I was curious what would be the code to make the comments resize vertically and not horizontally? Thank you very much for being willing to share all the great knowledge! Have a great day!!

[shg]

Please don't add a question to someone else's thread -- start your own.

Thanks.