Rolling countdown according to table


New Member
Apr 3, 2018
Hi all,

First off; I'm new here, so apologies beforehand if I'm not adhering to every convention on this forum...

OK. my challenge is the following: I was asked to create a schedule screen for the cart supplying our production lpines form the warehouse. They have a paper schedule on a messageboard now, but as the driver cannot check this, it often happens that production lines are over- or understocked. The screen will have to display the production line to be currently supplied, with a countdown timer, with underneath the following 3 lanes to be supplied, rolling up when the timer reaches zero, all the way to the end of the working day.

I have created a dynamic schedule file, taking into account the (variable) amount of lines, (variable) runtimes for supplying each line and fixed break times, which supplies a separate file that will be the display on the screen. It might be (over?)complicated, but it's now running completely reliably, after ironing out many, many bugs.

The second file has in one tab the day's schedule (fed by the first file) and another tab has the 'screen'.

I'm using two files, because the schedule file should be accessible while the other one will run the screen on a dedicated PC.

Using shameless copy and paste, I was able to get a countdown timer running in a 3rd file through a macro (to be run on the screen PC), which feeds the counter in the screen file for now.

And that's where I'm at right now.

So here's my problem: I am a complete VBA noob, and although I (usually) understand the logic in macro's I look into, I do not know where to start making the above happen.

That being, getting the rolling up of the lines on the large screen working according to the schedule I made, with each roll-up triggered by the countdown timer reaching zero.

I hope the above was clear enough and someone will be able to at least point me in the right direction...

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...