+ Reply to Thread
Results 1 to 7 of 7

Spinning Wheel

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    80

    Spinning Wheel

    Hello,

    I have this code to spin a a chart pie like a wheel:
    Please Login or Register  to view this content.
    What i want is to modify this code to do the following:
    > When i run the code it will spin fast then slowly until it stop
    > Spin it for at least 10 seconds

    Thank you in advance...

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Spinning Wheel

    Maybe something like this
    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    07-28-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Spinning Wheel

    Quote Originally Posted by Crooza View Post
    Maybe something like this
    Please Login or Register  to view this content.

    Thanks for the reply, but the whole chart and command button is flashing as well, and it takes too long to finish...

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Spinning Wheel

    It's flashing because of the screen update. Without this command though I couldn't get the chart to regenerate each loop. Maybe someone else will know how to do this without the screen update command. In regards to the time, change the loop size for j to a lower number than
    10

  5. #5
    Registered User
    Join Date
    07-28-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Spinning Wheel

    updating...

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Spinning Wheel

    Something like this?

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    07-28-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Spinning Wheel

    Quote Originally Posted by Andy Pope View Post
    Something like this?

    Please Login or Register  to view this content.

    Thank you so much! i works perfectly!

+ 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] VB Change Function, worked but cursor keep spinning loading
    By bhayu in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-27-2016, 12:57 PM
  2. Create Spinning Pie Chart with a Macro support
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-19-2013, 04:17 AM
  3. Copy Formula On Range leaves wheel spinning
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2013, 02:41 AM
  4. Spinning Roulette Wheel
    By bnitty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2013, 07:26 PM
  5. [SOLVED] Fix for mouse wheel in VBE
    By XP in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2006, 02:10 PM
  6. PS/2 wheel mouse in VBA
    By George in forum Excel General
    Replies: 1
    Last Post: 11-03-2005, 12:50 PM
  7. Insert spinning button with time format in Excel 2000?
    By Pat Hughes in forum Excel General
    Replies: 5
    Last Post: 10-26-2005, 08:05 PM

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