Re: Shape Height Goes Down!
- From: Susan <bogenexcel@xxxxxxx>
- Date: 7 May 2007 11:58:00 -0700
all i know is when i changed it to your code, when i incremented the
spin button it flipped the cylinder around 180 degrees WHILE it grew.
the next time i clicked the spin button, it flipped around 180 degrees
again, and grew again (or shrunk again, depending on which way i
clicked the spin button).
perhaps it's time for me to shuddup now. lol
i guess i don't think in more than 2 dimensions, especially when it
comes to excel!!!!
:D
susan
On May 7, 2:31 pm, Joel <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Susan: Its all RELEATIVE to the direction the part was placed on the
spreadsheet.. if you rotate the part 180 degrees it will grow in the
opposite direction. if yourotate it 90 degrees it will grow left and right.
the simple solution for Jason is to rotate the part in the correct directtion
so it grows the way he wants it to.
One pill makes you larger
And one pill makes you small,
And the ones that mother gives you
Don't do anything at all.
Go ask Alice
When she's ten feet tall.
And if you go chasing rabbits
And you know you're going to fall,
Tell 'em a hookah smoking caterpillar
Has given you the call.
Call Alice
When she was just small.
When the men on the chessboard
Get up and tell you where to go
And you've just had some kind of mushroom
And your mind is moving low.
Go ask Alice
I think she'll know.
When logic and proportion
Have fallen sloppy dead,
And the White Knight is talking backwards
And the Red Queen's "off with her head!"
Remember what the dormouse said:
"Feed your head. Feed your head. Feed your head"
An English mathmetician by the name of Charles Dodgson wrote a children's
book on the subject of higher dimensional geometry and parallel universes.
Under a pen name of Lewis Carrol, he wrote Alice's Adventures in Wonderland
in 1865. we are all familiar with the bit when Alice chases the white rabbit
down an Einstein-Rosen bridge into another universe. But it was called a
rabbit whole. Of coarse dodgson was unaware what sort of mechanism would
cause such a tunnel to join our wirld with another because it was before
relativity, quantum mechanics and modern cosmology. The story was based soley
on geometrical ideas about how space could be curved and how 2 spaces could
link together in some higher dimensional hyperspace. 50 years later Einstein
showed that such a curvature of space occurs wherever there is strong enough
concentration of mass (or energy). Theory of gravity (general relativity)
provided the physical basis for such tunnels to other worlds.
"Susan" wrote:
i'd be happy to send you the workbook if that would help..........
susan
On May 7, 2:10 pm, Susan <bogenex...@xxxxxxx> wrote:
ummm, what rotation bar???
:)
i drew a cylinder auto shape, stuck your code in the worksheet module,
adapted it to fit my autoshape (1), inserted a CONTROL BOX spin
button, changed the cell link to b1, and voila!
yes, it moves upwards, towards row 1.
if you make it big enough that it's hitting the top of row 1, then it
moves downward instead.
the only problem i have with it is that the cylinder doesn't exactly
stay PUT while it's growing & shrinking. each time i increment the
spin button, it moves slightly up & to the left.
this is the code i put in:
Option Explicit
Private Sub SpinButton2_Change()
Dim ws As Worksheet
Dim iLevel As Long
Set ws = ActiveSheet
iLevel = Sheets("Spin").Range("B1")
With ws.Shapes("AutoShape 1")
.Height = iLevel * 10
End With
'Joel said to try this, but it just makes for
'very interesting movement!
'With ws.Shapes("AutoShape 1")
' .Height = iLevel * 10
' .IncrementRotation 180#
'End With
End Sub
i commented out your code, & tried joel's, but all that does is flip
the shape around from top to bottom.
susan- Hide quoted text -
- Show quoted text -
.
- Follow-Ups:
- Re: Shape Height Goes Down!
- From: Nick Hebb
- Re: Shape Height Goes Down!
- References:
- Re: Shape Height Goes Down!
- From: Susan
- Re: Shape Height Goes Down!
- From: Joel
- Re: Shape Height Goes Down!
- From: Susan
- Re: Shape Height Goes Down!
- From: Susan
- Re: Shape Height Goes Down!
- From: Joel
- Re: Shape Height Goes Down!
- Prev by Date: Re: xl2007 and Windows Media Center
- Next by Date: Re: xl2007, problem with Activechart.Deselect
- Previous by thread: Re: Shape Height Goes Down!
- Next by thread: Re: Shape Height Goes Down!
- Index(es):
Relevant Pages
|
