I need to add time punches leaving out over lapping times
A time of punch
E Agent Name
F action (clock in or clock out)
J total time between clock in and out
I need to add up the times in column J that match an agent name and times do not over lap
I'm trying to create a stopwatch with a pause function in VBA for my excel document, but I have little to no experience in VBA. The other threads I have found didn't work for me (probably because of my lack of knowledge). I just want a simple stopwatch without using user forms as I want the time...
I have had a look round the site and couldnt see an answer on this what is probably a simple question.
I have a table of data lets say 5 columns by 5 rows as a named range called data.
I want to create a chart where the values loop through each column with a pause of lets say 5 seconds...
Hello. I'm having a problem with one specific Excel file. Excel seems to "pause" (become non-responsive) for 2-3 seconds after I type a number or text in a cell and then press "Enter" or an arrow key to move to another cell. It's almost as if Excel is recalculating - but recalculation is set...
Is it possible to do start and pause the time on VBA Form..?
I have select any activity type from Combo box 1.
Time start in Text box.
after half an hour, user wants to take a break. Here, user can click a button say, "Pause". It will stop that time, and if he selects...
Dim FilePath As String
Dim strFilename As String
Dim strTextLine As String
Dim iFile As Integer: iFile = FreeFile
strFilename = "C:\desktop\file.txt"
Open strFilename For Input As #iFile 'read each line in text individually
Application.Wait (Now + 0.0000058) 'wait for about...
ActiveWorkbook.Connections("Query - Actuals").Refresh
ActiveWorkbook.Connections("Query - SFDC").Refresh
ActiveWorkbook.Connections("Query - PW Most Likely").Refresh
I have just upgraded to Excel 2016 and I am wondering if excel 2016...
The problem I'm having is the vba is trying to process everything at once which is messing it up. I'm positive all the imputed code works.
I need a way to pause the macro for a set time to allow it to finish processing a part of the code before continuing. Application.Wait does not work it does...
As powerful as EXCEL is, I am hard put to believe that there is no way to have a macro pause, wait for user input (ended with a carriage return [the ENTER key for you young pups]), then continue the macro.
Simply put, I want the macro to select a cell, wait for input and an [ENTER] then continue...
I am looking for VBA code sample for the following situation....
My excel code currently does a REFRESH ALL DATA. At which point in the lower left is displayed the message, "RUNNING BACKGROUND QUERY ... (CLICK HERE TO CANCEL)". Also later at times when I refresh, I get a message...
I want to allow users to sort a protected worksheet. Apparently, this is not possible without unprotecting. This is the workaround I think about :
user launches macro (button, shortcut,...) that unprotects for, say 15 seconds.
user can now sort
vba reprotrects after the 15 seconds
I have this piece of code that is used to access a Link. Once this link is open, an excel file is automatically downloaded. This file is big and takes about 2 mins to open. The problem is that vba does not wait for the file and continues to the next line of code, which creates a...
I have an interesting problem. I thought Excel would not advance to the next line of the VBA code until all calculations were complete (assuming automatic calculations are turned on). However, that doesn't seem to be the case. So, I tried to add a while loop to allow it to run ALL...
The following macro is supposed to display the scores of a competition on a screen, moving down the scores until all have been displayed.
It worked fine in Excel 2003 but in 2007 or 2010 the screen does not refresh after the cursor has moved down to the fouth or fifth line of the results.
I have a macro as below that prints the sheet to a specific printer then it emails it to a recipiant selected from a userform "Email choice"
This macro is the macro in the userform for the first button on the user form "Email Choice"
I found that excel did not like running this if the print...
I'm having some trouble with a workbook that I've set to only calculate when the user clicks a button to force a total calculation with an
line. The trouble is *I think* that the code continues to progress while the sheet is rebuilding/recalculating, so it's...
I'm looking for a way to create a stopwatch/timer that can be paused and restarted without resetting. What this is doing is calculating how long it takes an employee to complete certain tasks.
Whence the timer is stopped I need data in specified cells to be logged on another sheet along with...
I'm trying to streamline a larger maco loop so that I do not have to re-run the macro each time I hit a needed user input. I'm not quite sure of the best way to go around this, so any "outside of the question" suggestions are welcome.
So here's the question: Is there a way to pause...
I am using Sendkeys for Hyperion Planning Excel Add-In User Interface in order to automate retrieving data from the database. Sometimes the UI is too slow and I'd need a little pause between Sendkeys commands. The most helpful solution was provided by TsTom year 2003 in this Forum, see...