pause

  1. C

    Sum

    I need to add time punches leaving out over lapping times Columns A time of punch D Queue 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 <colgroup><col...
  2. L

    How to create a stopwatch with pause function in VBA

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

    Vlookup change column looking at

    HI, 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...
  4. A

    Excel pauses 2-3 seconds after enter data in a cell

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

    VBA Form - Need Button - Time - Start & pause

    Dear All Is it possible to do start and pause the time on VBA Form..? For example, 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...
  6. V

    How to wait for text file to open before proceeding?

    Sub something() 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...
  7. K

    Excel2016 VBA to pause until PowerQuery has updated

    Sub PowerQueryRefresh() ActiveWorkbook.Connections("Query - Actuals").Refresh ActiveWorkbook.Connections("Query - SFDC").Refresh ActiveWorkbook.Connections("Query - PW Most Likely").Refresh End Sub Hi All, I have just upgraded to Excel 2016 and I am wondering if excel 2016...
  8. F

    VBA delay code?

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

    Pause macro for input then resume?

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

    Vba code to wait until query & calculations are complete before proceeding

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

    Set Macro to Wait/Pause

    I used to have a macro show a picture in the middle of the code and then continue. The code I can't remember is how to put in a pause for a given time period. Any help?
  12. J

    Pause vba for manual action in excel

    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 In other...
  13. S

    VBA skipping to the next line without waiting file

    Hello guys, 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...
  14. D

    Wait for Calculations to Complete

    Hi everyone, 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...
  15. B

    Pause

    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. Sub...
  16. T

    Pause macro until print job has finished

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

    Start Process, Wait Until Finished, Resume

    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 Application.CalculateFullRebuild line. The trouble is *I think* that the code continues to progress while the sheet is rebuilding/recalculating, so it's...
  18. C

    Stopwatch / Timer w/ pause function

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

    Macro Editting after Coming Upon needed User Input

    Hello, 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...
  20. M

    Delay for SendKeys, TsTom?

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

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top