ExcelBanter - is there a property instead of ScaleWidth method

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - is there a property instead of ScaleWidth method (https://www.excelbanter.com/excel-programming/437377-there-property-instead-scalewidth-method.html)

EXCEL$B!!(BNEWS

is there a property instead of ScaleWidth method

hi,
when i use ScaleWidth method like these

ActiveSheet.Shapes("Object 8").Select
Selection.ShapeRange.ScaleWidth 0.48, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.48, msoFalse, msoScaleFromTopLeft

i can make the shape smaller,

but how i can get the scale which has been "ScaleWidth"ed ,

is there a property instead of method

thanks

Rob van Gelder

is there a property instead of ScaleWidth method

Are you after the Width property?

On 14-Dec-2009 03:58, EXCEL　NEWS wrote:
hi,
when i use ScaleWidth method like these

ActiveSheet.Shapes("Object 8").Select
Selection.ShapeRange.ScaleWidth 0.48, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.48, msoFalse, msoScaleFromTopLeft

i can make the shape smaller,

but how i can get the scale which has been "ScaleWidth"ed ,

is there a property instead of method

thanks

All times are GMT +1. The time now is 06:01 AM.