timer

  1. D

    countdown timer

    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")...
  2. D

    VBA Timer with rolling list

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

    VBA Timer with rolling list

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

    Macro Wont Run When cell is selected ... Application.OnTime EarliestTime:=DownTime

    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...
  5. Jaafar Tribak

    Workbook BeforeClose Cancel button

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

    estimating execution time in VBA

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

    Rolling countdown according to table

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

    Error 438 in getElementsByClassName

    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 =...
  9. G

    Need VBA Code to Stop my Timer Macro!

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

    Send data from Excel/VBA to WAZE LIVEMAPS

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

    Using a countdown timer in a cell to run a macro

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

    build a tracking tool on Excel

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

    Macro won't stop..HELP!

    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 +...
  14. F

    Special VBA countdown timer

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

    VBA Code that resumes if no input is done after a certain period of time

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

    VBA for queue and countdown timer

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

    Help with the tic button, not the comand button

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

    Help with VB Code Please

    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()...
  19. G

    Help with VB Code Please

    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()...
  20. R

    Timer works but can't view another workbook

    Hello- I have code to run a timer to make cells blink and make beep sound if certain range values are met. It works great. But, if I open another workbook it goes to the background when the timer runs. So I can't view another workbook when the timer is running. If I turn the timer off then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top