Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spin button which lengthens pictures (Excel 2000)

    Hello Woodys Lounge,

    I am working on a spreadsheet which has a diagram that I would like to control with a spin switch,

    The diagram has 4 pictures, but the pictures work together.

    the 4 pictures are Right Case and Left Case, which are a pair
    and RightOpen and LeftOpen which are a pair

    I am trying for a way to lengthen the pictures by the control of a toggle switch.

    If the toggle switch is click down then RightCase and Left Case lengthen and RightOpen and LeftOpen shorten and Vice versa if the up arrow is click on the spin button.

    I make this spin button work the way Iwant it to so hopefully some one know a way.

    Attached is myworkbook which has the starting of code behide the spin button, (I removed what I know was not going o work)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spin button which lengthens pictures (Excel 2000)

    The control on your worksheet is a spin button. It is meant to increase or decrease a variable repeatedly. If you want a toggle, a toggle button might be a better choice. See attached version. There is code in the worksheet module (the On Click procedure of the toggle button) and in the standard module.

  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spin button which lengthens pictures (Excel 2000)

    Hi Hans,
    Thank you for the reply.

    I am trying to increase the pictures by multiple increments .5 for example up and down so thats why i used a spin button

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spin button which lengthens pictures (Excel 2000)

    I don't think Excel is the ideal application for that. Perhaps you should look for animation software.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Spin button which lengthens pictures (Excel 2000)

    Patrick,
    Try the attached. You may need to tweak it as the images can get a little distorted. Note: I grouped the pairs of shapes for easier coding.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spin button which lengthens pictures (Excel 2000)

    Thank you, works great,

    One question is when I make some new shapes to replace the old ones The seem not to heighten but rather widen as the spin button is clicked, any reason for this
    and how should I go about making my shapes?

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Spin button which lengthens pictures (Excel 20

    I'm not sure why that would happen - can you post a sample showing the problem?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •