LinkBack URL
About LinkBacks
I would like to use the data in the upload to create an animated line chart.
Is there a simple way to do this? Thanks for any help....
Here is a link to show what I am looking for:
http://www.youtube.com/watch?v=yph8TRldW6k
I would like to use the data in the upload to create an animated line chart.
Is there a simple way to do this? Thanks for any help....
Here is a link to show what I am looking for:
http://www.youtube.com/watch?v=yph8TRldW6k
Try this macro.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for the help....I get this error about 64 bit systems
https://dl.dropboxusercontent.com/u/90210377/error.JPG
Last edited by lovethepirk; 08-08-2013 at 04:50 PM.
I couldn't get the VBA to work so what I have done is attached. I added a 'scrollbar'
I would like to be able to click a 'play button' to run through the entire scroll bar
Is there a way to do this instead of clicking the scroll bar 237 times.
Thanks.
Try this. The #IF #Else #Endif statement goes at the very top of the code module in the module's Declarations section.
Please Login or Register to view this content.
Thanks so much.
Attached is the result so far, check it out.
Is there anyway to have a button to stop the macro?
Not sure about how to make a stop animation button. There's probably a clever way to make it happen though.
You can hit the space bar or any character key to stop the code. Note: what you type goes into cell H1 as it's the active cell.
Please Login or Register to view this content.
@Andy Pope
That toggles the button caption, but the button isn't click-able while the code is running. So it doesn't stop the code. What am I missing?
Looks like it needed the button pressed twice in order to get it going.
I've changed the logic and variable name and now it should anitmate on first press. Note I've increased the speed of anitmation.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks