Shape Height Goes Down!
Hello. I have a shape (cylinder) that changes height when I change the value
via a spin button. However, instead of the shape increasing in height, it
decreases from the base (i.e. the shape stretches down the worsheet as I
increase the value).
I need the cylinder to increase in height (upward), not down. Using XP
Office, XL2000. Thanks.
Private Sub SpinButton3_Change()
Dim ws As Worksheet
Dim iLevel As Long
Set ws = ActiveSheet
iLevel = Sheets("Spin").[B23]
With ws.Shapes("AutoShape 11")
.Height = iLevel * 10
End With
End Sub
|