timer

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

Good Afternoon! I found the below code in a previous string years ago and plan to use for safety recognition (similar to drawing a name from a hat). However, I know very little about VBA. Can someone please help me identify how to modify this code to have the chart rotate longer? Maybe at...

I know this may not enough information but this could become pretty complex. Here is what I created. I have two Userform Buttons on my worksheet which fills out a spreadsheet with whatever the user enters. Everything works great (thanks to some people on this board ;)). Now my issue lies in...

Hi all, I am using this code in a workbook to activate a timer when it is opened, then after 15 minutes make it close and save changes. my question is, if I have this workbook open, then open another the timer seems to activate on that one too, then as a iswitch between it starts the timer...

Hello: I have what has turned into a complicated, but nice workbook, at least for our purposes, thanks to some direction from all of you. It is a project plan workbook with a GANTT chart that is pulling from 2 SQL databases and 4 other workbooks located on the network to update all of its...

Hello, I have a userform that when completed tells the user that either a row was updated, or a new row was inserted via two simple labels that appear with the information as required. Is there a way to show these labels for only 2-4 seconds before it automatically gets hidden?

Hello everyone great forum (first time poster) i have a spreadsheet that has a userform built in to it that when the form is opened it starts a timer, the form is completed and on exiting the timer stops and calculates the time the userform is open. when closed the form populates certain cells...

I'm stuck on a timer issue. I need a timer that is automatically activated upon opening excel (not clicking a button to activate it) I have multiple sheets so far and I need a timer to automatically add the value from sheet1 C14 to cell E14 in the same sheet every 3 seconds. C14 starts at 0 but...

A couple of days ago the site where I get my currency from made some changes and killed my project :/ I'm just finished rewriting this. Earlier I had just web page import in excel which worked just fine , but now I have rewritten this as a web scraping project and I'm proud to say its working...

I wrote a macro that allows a user to time the duration of their call through a UserForm, while they continue to enter data about their call on an excel sheet. Most of the time the macro works perfectly but occasionally (randomly it seems) I get an error when attempting to pause/stop the OnTime...

I have a long piece of code (not worth posting in full) that loops through a folder of excels and performs 7 different procedures on them. The issue is that a given workbook will sometimes encounter issues (usually related to the internal structure or size of the workbook) which can cause the...

I wish to execute a specific macro every minute or every 10 minutes after 4 pm. Can someone please tell me if this is possible and if so, how can I do this in VBA? Thanks in advance.

Hi all I am trying to create an excel tool that will sit in the background on my teams computers. I want a macro on it that will automatically start running a timer everytime they open an email and automatically stop when they close it. I want this time to then drop onto a second tab on the...

Hello everyone, New to the forum and kinda new to the excel VBA but I know more about VB. First I will say I work in steps meaning this question may be leading to something bigger. Im using 2016 Pro Plus. My goal here: Not necessarily using the code I am providing, I wish to compare 2 cells...

Hi! Is it possible to have a timed macro which sends a selection of data from excel in an email (one email address) on an hourly basis?

Hello Everyone i am new here and have a question i cant seem to find a answer to. Ok so i have a spreadsheet that tracks labor for a company i work for and they have provided bar codes to employees for there badge ids but they also have bar codes for activities that they choose not to use and...

I am looking to create a spreadsheet that will allow me to track my time by day and cost center. Each cost center will have a stop and start timer for each day of the week and can be started and stopped multiple times. It will look something like this.... Cost Ctr 01/04/16 01/05/16 01/06/16...

Hey guys!! In VBA i made a countdown timer, when it gets to 0 it executes an .wav audiofile then the countdown timer resets and counts down again. The problem is the code waits for the audiofile to play (~3 sec) before continuing. So you could imagine, if I counted down for 1min, the actual...

I have created an Excel test for our group at work, and my boss has asked me to put in a 30 minute countdown clock that will lock the spreadsheet down after 30 minutes (of if they finish early and press the Start/Stop button). I would like the timer to be started and stopped by a Start/Stop...

Dear Colleagues, I have a race after 3 days and I need an excel sheet with a stop watch timer to record all racers results once I entered the racer number.. as below sheet exactly. https://www.youtube.com/watch?v=PMQiStqrNwg I appreciate your prompt help with needed excel sheet. Regards...