Hi, I have followed the YouTube tip below to create a resized object based on the results of a formula.
It works pretty well, but I want to ensure the aspect ratio of the object is maintained as a perfect square.
I've used the below but for some reason even though the width and height are referencing a value in the same cell the aspect ratio doesn't stay constant
With ActiveSheet.Shapes.Range(Array("square1"))
.Width = Range("B3").Value
.Height = Range("B3").Value
End With
Any thoughts?
It works pretty well, but I want to ensure the aspect ratio of the object is maintained as a perfect square.
I've used the below but for some reason even though the width and height are referencing a value in the same cell the aspect ratio doesn't stay constant
With ActiveSheet.Shapes.Range(Array("square1"))
.Width = Range("B3").Value
.Height = Range("B3").Value
End With
Any thoughts?