Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
How to change comment Box width and high. Below is records vba, but Selection.ShapeRange.ScaleWidth have error. How to change set comment Width ? Sub Macro1() ' Range("S19").AddComment Range("S19").Comment.Visible = true Range("S19").Comment.Text Text:="e:" & Chr(10) & "" Selection.ShapeRange.ScaleWidth 5.05, msoFalse, msoScaleFromBottomRight Selection.ShapeRange.ScaleWidth 1.24, msoFalse, msoScaleFromTopLeft Range("S19").Comment.Shape.Select True Range("S19").Comment.Text Text:="e:" & Chr(10) & "zxdfdf" Range("S23").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert Comment in Current Call and set then width | Excel Programming | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
change the color of a number when it gets too high | Excel Discussion (Misc queries) | |||
Bar charts: change color of a bar if value too high? | Charts and Charting in Excel | |||
How to change Macro security level very high to low... | Excel Programming |