
VBA module required to create a scrolling dashboard
- or -
Post a project like this1889
£100(approx. $134)
- Posted:
- Proposals: 12
- Remote
- #3041271
- PRE-FUNDED
- Completed
Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!

1792694338350349847873514702642406366686327441385066635495956183750797270269
Description
Experience Level: Entry
I have a dashboard built in Excel which shows a list of jobs with planned time and actual time worked on them. This is to be displayed on a large screen in our workshop for supervisors to refer to in order to track jobs. The workbook uses ODBC links to an underlying database which refresh every 15 minutes. I have written VBA modules to calculate one of the fields in the dashboard and to run refresh all every 15 minutes from the point the workbook is opened.
The problem I have is that there are more fields in the dashboard than can be displayed on one screen. I therefore need to write a VBA module that scrolls the dashboard (like the departures board at an airport). I have written one but it creates an infinite loop which I am concerned will crash the workbook or prevent the "refresh all" code from running every 15 minutes.
The key requirements are as follows:
1) I need the code to start automatically once the "refresh all" code has run;
2) I need it to stop every 13 minutes so that the "refresh all" code can run successfully, or at least to run in a way that does not interfere with the "refresh all" code;
3) I need the screen to always show data in every row (ie the last screen in the loop should not show two or three lines of data and then 50 blank rows);
4) I need to be able to alter the time that the loop takes between scrolls based on user feedback;
5) I need to be able to alter how many rows that the loop jumps in each scroll (as I do not yet have the screens set up, so don't know how many rows will fit on the screen at the desired resolution).
6) The dashboard is filtered to exclude jobs with 0 actual hours (ie jobs that haven't started) and to only show jobs for the relevant department - the scrolling needs to work with these filters still in place
I've uploaded the workbook with the macros disabled and the ODBC links removed. If the existing VBA modules are not visible please let me know and I will upload them too.
The problem I have is that there are more fields in the dashboard than can be displayed on one screen. I therefore need to write a VBA module that scrolls the dashboard (like the departures board at an airport). I have written one but it creates an infinite loop which I am concerned will crash the workbook or prevent the "refresh all" code from running every 15 minutes.
The key requirements are as follows:
1) I need the code to start automatically once the "refresh all" code has run;
2) I need it to stop every 13 minutes so that the "refresh all" code can run successfully, or at least to run in a way that does not interfere with the "refresh all" code;
3) I need the screen to always show data in every row (ie the last screen in the loop should not show two or three lines of data and then 50 blank rows);
4) I need to be able to alter the time that the loop takes between scrolls based on user feedback;
5) I need to be able to alter how many rows that the loop jumps in each scroll (as I do not yet have the screens set up, so don't know how many rows will fit on the screen at the desired resolution).
6) The dashboard is filtered to exclude jobs with 0 actual hours (ie jobs that haven't started) and to only show jobs for the relevant department - the scrolling needs to work with these filters still in place
I've uploaded the workbook with the macros disabled and the ODBC links removed. If the existing VBA modules are not visible please let me know and I will upload them too.
Jack D.
100% (5)Projects Completed
8
Freelancers worked with
8
Projects awarded
25%
Last project
10 Jul 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies