change comment text font size - AndreaVB Visual Basic and VB.NET source code discussion board

Previous Topic (HELP - Communicating between C++ and VBA)

AndreaVB Forum : VBA (Access, Excel, Word, ...) : change comment text font size

Poster

Message

Cathy
Level: Big Cheese

Registered: 08-07-2003
Posts: 22

change comment text font size

Call all Gurus:
anybody know how to change comment text font size?

09-07-2003 at 03:47 AM

~Bean~
Level: VB Guru

Registered: 07-04-2003
Posts: 488

Re: change comment text font size

you mean using VBA, right?

I don't think you can do this...

sry

____________________________
Eggheads unite! You have nothing to lose but your yolks.

10-07-2003 at 02:35 PM

steve_w
Level: Moderator

Registered: 18-04-2003
Posts: 1159

Re: change comment text font size

Took a bit of digging but heres how!

Range("c8").Comment.Shape.TextFrame.Characters.Font.Size = 10

Steve

10-07-2003 at 10:24 PM

~Bean~
Level: VB Guru

Registered: 07-04-2003
Posts: 488

Re: change comment text font size

LMAO! I was such an unbeliever I had to try that out for myself Steve! LOL!

GJ Hook!

____________________________
Eggheads unite! You have nothing to lose but your yolks.

11-07-2003 at 12:49 PM

steve_w
Level: Moderator

Registered: 18-04-2003
Posts: 1159

Re: change comment text font size

Bit ridiculous isn't it.

Talk about wanting to hide it

[Edited by steve_w on 11-07-2003 at 01:25 PM GMT]

11-07-2003 at 12:52 PM

Cathy
Level: Big Cheese

Registered: 08-07-2003
Posts: 22

Re: change comment text font size

Thank you Steve, you are Genius

13-07-2003 at 11:33 PM

AndreaVB Forum : VBA (Access, Excel, Word, ...) : change comment text font size


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2009 Andrea Tincani