chirayu
Well-Known Member
Hi Guys,
This is a report I made in my previous company in 2013. I have removed the company name, logo and changed the names of processes/ people in the report so I can upload it for you guys to check out & experiment with.
Basically its a line chart that is controlled by VBA. It has day on day data in the report with forward/back/pause buttons that allow u to dynamically 'run' the chart (you'll understand what I mean when you use it). While the chart is running you can use the dropdowns to change the 'skill/ employee'. You can also pause the macro & use the scroll bars manually. Macro runs on a loop & goes to start of data range once data is finished.
I have to say that the VBA code is a modified version of a code I had found in 2013, but I forget the source. If someone else can figure it out & post it then great![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
This is a report I made in my previous company in 2013. I have removed the company name, logo and changed the names of processes/ people in the report so I can upload it for you guys to check out & experiment with.
Basically its a line chart that is controlled by VBA. It has day on day data in the report with forward/back/pause buttons that allow u to dynamically 'run' the chart (you'll understand what I mean when you use it). While the chart is running you can use the dropdowns to change the 'skill/ employee'. You can also pause the macro & use the scroll bars manually. Macro runs on a loop & goes to start of data range once data is finished.
I have to say that the VBA code is a modified version of a code I had found in 2013, but I forget the source. If someone else can figure it out & post it then great