Scaleheight of image

[Roderick_E]

Trying to get and set an image's scaleheight and width

msgbox activesheet.Shapes(1).ScaleHeight

returns nothing. I realize there are 3 parts to Scaleheight and width

Help a brother out? Thanks

 

[Fluff]

ScaleHeight is a method not a property & needs the first 2 arguments
ScaleHeight( Factor , RelativeToOriginalSize , Scale )

 

[Roderick_E]

How do I get the stored arguments of an existing image so that I can set another image to match it?

 

[Fluff]

I've no idea, assuming it's even possible.
Couldn't you just get the height & width & use that?

 

[Tetra201]

Maybe

Dim SHValue As Single
SHValue = ActiveSheet.Shapes(1).Height
ActiveSheet.Shapes(1).ScaleHeight 1, msoTrue
SHValue = SHValue / ActiveSheet.Shapes(1).Height
ActiveSheet.Shapes(1).ScaleHeight SHValue, msoTrue

 

[Roderick_E]

I've no idea, assuming it's even possible.
Couldn't you just get the height & width & use that?

I already set the height and width yet for some reason the scale is not the same when just doing that.

 

[Roderick_E]

Maybe

Dim SHValue As Single
SHValue = ActiveSheet.Shapes(1).Height
ActiveSheet.Shapes(1).ScaleHeight 1, msoTrue
SHValue = SHValue / ActiveSheet.Shapes(1).Height
ActiveSheet.Shapes(1).ScaleHeight SHValue, msoTrue

height and scaleheight's SHValue as you dim it here are not the same. height is typically in pixels and scaleheight is a percentage. I'm beginning to think it can't be done

 

[Tetra201]

height and scaleheight's SHValue as you dim it here are not the same...

From the MS help:

Shape.Height Property (Excel) -- Returns or sets a Single value that represents the height, in points, of the object.
Shape.ScaleHeight Method (Excel) -- Syntax: expression.ScaleHeight(Factor,RelativeToOriginalSize,Scale); Factor: Data Type Single.

 

[Roderick_E]

From the MS help:

Shape.Height Property (Excel) -- Returns or sets a Single value that represents the height, in points, of the object.
Shape.ScaleHeight Method (Excel) -- Syntax: expression.ScaleHeight(Factor,RelativeToOriginalSize,Scale); Factor: Data Type Single.

Hmmm... and I tested your code. Seems to work on a test, now testing on my real project....

 

[Roderick_E]

So the same concept doesn't work for Width?