Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change comment Box width and high
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 | |
|
|
Similar Threads | ||||
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 |