Hi,
I used Record Macro to create a comment. The VBA code is as follow:
Range("C1").Select
Range("C1").AddComment
Range("C1").Comment.Visible = False
Range("C1").Comment.text text:="Test: A1 " & Chr(10) & "Result: 56"
Selection.ShapeRange.ScaleWidth 5.87, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 2.26, msoFalse, msoScaleFromTopLeft
Once run Macro, get a error message:"Object doesn't support this property or method" for the statement "Selection.ShapeRange.ScaleWidth 5.87, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 2.26, msoFalse, msoScaleFromTopLeft"
Please help!! Big Thanks!!
ssunchen
I used Record Macro to create a comment. The VBA code is as follow:
Range("C1").Select
Range("C1").AddComment
Range("C1").Comment.Visible = False
Range("C1").Comment.text text:="Test: A1 " & Chr(10) & "Result: 56"
Selection.ShapeRange.ScaleWidth 5.87, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 2.26, msoFalse, msoScaleFromTopLeft
Once run Macro, get a error message:"Object doesn't support this property or method" for the statement "Selection.ShapeRange.ScaleWidth 5.87, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 2.26, msoFalse, msoScaleFromTopLeft"
Please help!! Big Thanks!!
ssunchen