Posted to microsoft.public.excel.misc

Pete at Sappi Fine Paper

Posts: n/a

How do I re-size a comment box using VBA?

Recording a macro does not help - it gives:

Selection.ShapeRange.ScaleWidth 0.41, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.22, msoFalse, msoScaleFromTopLeft

But replacing "Selection" with "Range("B" & 15).comment" does not work.

Any ideas, please? Thanks!

Pete

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I change default font size for comment boxes in Excel?	Vormov	Excel Discussion (Misc queries)	1	October 28th 05 09:33 PM
Comment size	Don	Excel Discussion (Misc queries)	1	October 26th 05 04:36 AM
Default cell comment fill color and font size	Shadowman13	Excel Discussion (Misc queries)	2	September 28th 05 08:16 PM
Comment window size	Eddie	Excel Discussion (Misc queries)	1	March 24th 05 06:11 PM
changing comment indicator size or shape	Mrocka	Excel Worksheet Functions	1	December 13th 04 02:53 PM

All times are GMT +1. The time now is 02:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us