+ Reply to Thread
Results 1 to 3 of 3

Speed of rotation

  1. #1
    Registered User
    Join Date
    11-08-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    45

    Speed of rotation

    Hi is there a way of changing the speed of rotation of a shape?.

    For example I want to have a cell in the following workbook that relates to speed that can be easily adjusted to increase or decrease the speed that the rectangle rotates at.


    aRotating_Rectangle.xlsm

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Speed of rotation

    to make it rotating faster you can change incrementing
    for instance

    Please Login or Register  to view this content.
    for quicker - you are anyway dealing with floating point numbers - why not use

    Please Login or Register  to view this content.
    and then correct for smaller values other places, like:
    Please Login or Register  to view this content.
    etc.

    By the way - there is no good reason to do this part:
    Please Login or Register  to view this content.
    (or by 1800 in the above example)
    inside the loop (twice - both for left and top).
    Consider calculating it before the loop starts and storing in additional variable.
    Best Regards,

    Kaper

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Speed of rotation

    You could speed it up by adding steps
    The larger the step the faster
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Call Rotation Help
    By aharb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:48 PM
  2. Server Rotation
    By KSM244 in forum Excel General
    Replies: 0
    Last Post: 11-04-2013, 07:53 PM
  3. shiftwork rotation
    By phuongtran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2012, 06:25 AM
  4. Shift Rotation
    By gloom52 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-10-2009, 11:58 AM
  5. [SOLVED] Rotation property?
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2005, 09:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1