timer

I am having trouble with my vba program that is supposed to pull data from 2 databases and then copy and paste the data into a new workbook. The code itself for the data pull and the copy and paste works fine when I run the modules alone. When I put the modules in the automatic timer they seem...

Hey guys i have taken some code from online to create a countdown timer and when it hits 00:00:00 a msg box pops up but i want the box to pop up when the timer hits 00:05:00 (5 min remaining ) can anyone help? thanks Public gCount As Date Sub Timer() gCount = Now + TimeValue("00:00:01")...

What I was asked to do is to create a countdown timer that starts with the first value in a predetermined list of roundtrip times, and when it reaches zero, it has to move on to the next value and so on, till the list has been completed and then stop. This list with time values will eventually...

What I was asked to do is to create a countdown timer that starts with the first value in a predetermined list of roundtrip times, and when it reaches zero, it has to move on to the next value and so on, till the list has been completed and then stop. This list with time values will eventually...

Hi all, I have a workbook that we use in work in work with a timer function that shuts down the workbook when the workbook hasn't been used for 15 minutes. However, if my peers select a cell and go into edit mode then no macros run and then they go home so no one can edit it. Is there a...

Hi dear members, Let's assume there is a workbook project where an API timer (SetTimer) is started in the workbook open event... This timer is supposed to be running thoughout the life of the workbook until it is closed. In the workbook before_close event, the timer is cancelled by calling the...

Hi! :) I was wondering if there is a code to ESTIMATE run time of a macro (before going through all of the loops and calculations). I already incorporated elapse time and timer but the result comes out after the total execution of the codes and hence shows how long it took place. Any help or...

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...

Hello everybody. I don't understand why this error in getElementsByClassName. I'm logging in a navigating a site via vba. Sub navigate() Dim myId As String, myCode As String Dim IE As Object myId = "user" myCode = "password" myURL = "https://example.com/wwww/" Set IE =...

Hi so I've created a macro that starts a timer and alerts me when the countown is complete. I'm creating a multiple choice question sheet and have 5 multiple choice questions timed. Less than 2 minutes each. I'm struggling to find a code that will stop the timer when they've answered. THanks.

Please, i'm trying to query routes in WAZE LIVEMAP (https://www.waze.com/livemap), but i can't manipulate the elements. Has anyone done this? From point A (FROM) to point B (TO). Well... i can send the Excel data to point A (FROM), but then I can not open the INPUT in Waze to insert the data...

Hi there At various times during the day I need to take a snapshot of data totals in a spreadsheet. I have a macro set to simply pick up the values in the range I need (H9:I60) and copy them as values into AA9:AA60 I also have a countdown timer running in cell F9 to the next delivery point...

Hello i was wondering if you can help me with my dilemma. i run a small website with a small team of just two people, but i want to make sure they are updating our main attraction on the homepage regularly and be able to track that meticulously. this main attraction is square shaped and...

So several of you helped me with the code below which is designed to track time on a spreadsheet. It is here: Sub Recalc()With Sheet1.Range("U1") .Value = Format(Time, "hhmm;@") End With Call SetTime End Sub ---------------------------------------- Sub SetTime() SchedRecalc = Now +...

I am creating a board game and I'm incorporating Excel into it. What I'm looking for is a countdown timer that allows me to slowdown the timer. exp: Instead of it counting down 1 second at a time it will count down 1 second every 1.5 seconds.

Hello, I am trying to create a decision/choice game on excel using VBA. When the user clicks on the "Start" button, the excel will display a hidden sheet with a riddle on it. On this sheet, the user is required to give a numerical answer in cell C5. I want the vba code to either continue...

I have this VBA code that I use to create queue and remove from the queue and start countdown timer. C1 has drop down menu that user can select from it and click on ADD button and then you have a new name in queue which is column A. It is working but I have some issues: Issue1: I only want the...

This code works with comand buttons. I have tried to do it with just buttons but can't get it to work. When I click on a button it starts the timer, when I click on a different button it stops the running timer then starts the next timer. I need it to work with the tic button not the comand...

I have this VB code in Module1 Dim TimerActive As Boolean Sub StartTimer() Start_Timer End Sub Private Sub Start_Timer() TimerActive = True Application.OnTime Now() + TimeValue("00:00:01"), "Timer" End Sub Private Sub Stop_Timer() TimerActive = False End Sub Private Sub Timer()...

I have this VB code in Module1 Dim TimerActive As Boolean Sub StartTimer() Start_Timer End Sub Private Sub Start_Timer() TimerActive = True Application.OnTime Now() + TimeValue("00:00:01"), "Timer" End Sub Private Sub Stop_Timer() TimerActive = False End Sub Private Sub Timer()...