timers

I am trying to make a Timer executing a sub every second. I need a delay of 1 second then executing sub. Public TimerValue As Variant Public TimerTick As Variant Private Sub Window_Open() TimerValue = 1 TimerTick = Now Do While TimerValue <> 0 TimerTick = TimerTick +...

Hi, May seem a simple question but I have spent hours googling and cant work it out, in a userform I have 2 command buttons and 1 text box. when I press commandbutton4 I want textbox5 to start counting up in seconds. When I press commandbutton5 I want the timer to stop. Any help would be appreciated

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

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

I have searched and searched, but not found an answer to this: I have a workbook that is shared by users, and needs to be auto-closed after 10 minutes of inactivity. The VBA code to close the workbook if no changes have been made in 10 min works OK. However, I want to give a user who has been...

Hey Guys, I am pretty new to VBA and have never really had any training with coding for it. I am setting up an automated report but am having trouble getting the application on time event to run more than 24 hours. The Reportupdate Sub updates quite a few cells based on the current, that why...

Hi all :) I am having real fun here,, I have a constant flow of data that is coming from a different program that inputs its results into a cell in excel. What I am trying to do is set up excel to move down to the next cell at a set period, say every 15 mins, so that the data stored is in...

The code below is what I use to shut excel down at a certain time. I would like to have some code that at say 3:30pm a message box will pop up that says "Send Form Before your shift ends" Thanks as Always Sub RunOnTime() dTime = TimeSerial(16, 31, 2) Application.OnTime dTime, "QuitExcel" End...

I am using excel 2007 & 2010 I have 2 problems: 1) I need to change a formula that now calculates the military time difference between column J and column K. This formula works very well but I need it to also not calculate when only coulmn K contains a date. When both column dates are...

I have a document that I have set up to automatically save and close if not used for 10 minutes. I want to have a message box appear to ask the user if they are finished with the workbook before it just closes, but after 30 seconds if there is no reply, have the workbook close automatically...

I am able to fill a table containing ‘Start of Lap’ & ‘End of Lap’ based on my inputs from the range B2:D5. <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 4.65pt; WIDTH: 453pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0...

Hi, I have been given a process improvement to investigate which involves looking at how we can improve the performance of our spreadsheets within the team. Currently we run a swathe of spreadsheets across the team which (for some reason) we are unable to share. We constantly have issues with...