Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row Height stopped growing and Auot-Fit Row Height does not work | Excel Discussion (Misc queries) | |||
Evaluating if a Shape is a line or a shape | Excel Programming | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |