pause macro

  1. J

    Pause Macro Until File is Downloaded and Opened

    Hello: I have the below macro which pulls in an excel file from the Bloomberg application. Microsoft excel does not stop processing the VBA. I need the macro to stop until the file named "grid*.xls" is opened, and then start again so I can copy and paste the data. Please advise - been stuck...
  2. M

    Excel VBA Macro With Time Pause for Add-in

    Hi, 1> I have an Excel Macro that involves copying a bunch of formulas into many cells based on an Add-in. (i.e., Copy $A$2 to $A$3:$A$100, then $A$2 to $A$101:$A$200, etc.). I have to run these sequentially as otherwise the application runs out of memory (RAM is not the issue here). 2> The...
  3. L

    I need to pause macro so user can select sheet in which to copy current data into

    I need to write a macro that copies everything in current sheet, (variable sheet one), pauses for user to select new sheet tab, copy the data to the selected sheet, then value the data in (variable sheet on).
  4. E

    Create Button That Prompts User To Select Active Cell

    Hello, I have a macro that uses the active cell to sort through data and fill the acceptable data into three new columns. I wanted to see if someone could help me create a button that prompts the user to select the active cell and then runs through my macro code. This would be very helpful in...
  5. 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...
  6. D

    Input Box Assistance

    Hello All, I'm just getting started with VBA - trying to teach myself. I was lent a book by a colleague and that's helped a lot, but I have an issue for this particular project that I can figure out. I'm sure it's a bit complex for a first time project, but I wanted to tackle something that...
  7. T

    Wait until correct url is loaded

    i want to use something like application.wait but instead of a certain amount of time. i want the macro to wait until a specific url is loaded. something like application.wait ie.locationurl = "www.google.com" but obviously not that, because i can only specify an amount of time to wait and...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top