Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My thanks to William West for his assistance in providing
the following code. What I need to do is to set a standard size for the comment boxes. So far, the longest comment is 689 characters in length. I had found some code that auto- sized the comment box but this just put the entire comment on a single line. So, my question is: How do I set a standard size for all comment boxes? Comment box = X width by X height Here's the code: Sub ConvertTOComments() With ActiveSheet Dim r As Range, c As Range Set r = .Range("cmts") For Each c In r c.AddComment c.Comment.Text Text:=c.Text Next c End With End Sub Thanks for you assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA "auto-sizing" comment box | Excel Worksheet Functions | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
Comment Box Auto-sizing | Excel Worksheet Functions | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
Comment Box Sizing | Excel Programming |