waiting

  1. D

    Adding a waiting 3D animated icon to code

    Hello all, My code is working as intended. There is a long waiting period as a consequence of the code run that I would like to call a 3D animated model I have to just run onscreen while the code is running in the background. I cannot figure out how to call it from VBA to appear as this...
  2. Y

    Stopping A Looping of Files At Half Way

    I am reading a bunch of text files in a folder through loop. Using possibly a command button, how can i halt the loop half way instead of waiting for it to complete before i can do some other things.
  3. R

    Is there a more efficient method of updating the data in my list on Sharepoint?

    I need to know if there's a more efficient way of uploading data to my list on Sharepoint. I have a worksheet with an average of 100 rows and 106 columns, making a total of approximately 9,900 cells. This is my current process to upload: I go to my list on Sharepoint, viewing it in edit mode...
  4. M

    vba excel

    hello everyone, I have a question regarding vba if I move a data from file a to file b when pressing f8 the process repeats thus in file b there will be a duplication what can I do to remove duplication using the vba of file a waiting for a reply asap thank you
  5. A

    Enter today's date if there is a change in another cell

    Hello, I am trying to complete the situation stated above. I need a waiting day results. There are 4 related columns. 1:process column(selecting from drop down list). 2:process last update date. 3:today's date. 4:waiting time result. 1,3 and 4 is okay. But I need help on second column. When...
  6. K

    VBA code help to populate text in a specific column based on another column condition

    if any row in column J that = ATO then I need every row in column O to populate "Automated". Also if any row in column J = PRD and any row in column L = "waiting" then I need every row in column O that satisfies both criteria to = "Manual".
  7. S

    Summing data by matching dates that fall between 2 others

    Hi I have a problem. I have 2 sets of data. The first set contains movie times This is calculated by subtracting the current time from the previous rows time. The second set of data are instances that are described as waiting time. an instance of waiting time should fall between a move time...
  8. B

    Historically calculating weeks waiting by week

    Hi all, I have a table of customer who are awaiting or have had a procedure in a table like this: <tbody> Customer ID Procedure Request Date Completion Date 0001 Echo 2018-04-02 2018-05-05 0002 Echo 2018-05-06 2018-05-27 0003 TILT 2018-05-07 2018-05-20 0004 Echo 2018-05-19 </tbody>...
  9. M

    "Waiting for another application to complete the OLE action"

    Dears, good morning! I developed an application to access a web page. I encountered a problem after login. When clicking on the "Submit" button, a form will appear to select some combos, while the macro is waiting to close the form to continue, with this message: "Waiting for another application...
  10. M

    **Macro is waiting to close the form**

    Guys, good afternoon! when you log in via vba excel on the page, you open a form in .asp, the macro does not continue, it stops waiting for the form to close. I need the macro to continue ... Can you help me?</pre>
  11. M

    "Waiting for another application to complete the OLE action" error in Excel

    Dears, good morning! I developed an application to access a web page. I encountered a problem after login. When clicking on the "Submit" button, a form will appear to select some combos, while the macro is waiting to close the form to continue, with this message: "Waiting for another application...
  12. R

    Combining first come first served with random selection from a waiting list.

    I'm part of an organisation that is altering the way it manages a waiting list, and we have decided we want a way of picking n people per year to join. However, we don't want this done on a first-come-first-served basis, nor do we want an entirely randomised selection, rather a combination of...
  13. R

    IF (or similar) based on various list of options

    Hi, I'm sorry for the title being so vague, but i quickly need to run some numbers and the source data is a bit messy. The simplest way for me to do this with my limited knowledge is an IF statement, but i think it's going to be very messy in terms of nested IFs to do what i need, so i wonder...
  14. T

    VB: Filter based on today's date/date in column AND text in another

    Hi all, I was using a macro attached to a button to filter rows based on the colour of a cell (determined by conditional formatting). The code was: ----------------- Sub Due() ' ' Due Macro ' ' ActiveSheet.Range("$B$1:$Z$5997").AutoFilter Field:=10, Criteria1:=RGB(218, _ 150...
  15. D

    Comparing Values in Excel

    Hi All, I need help for the below: A1 A2 A3 0 0 display "blank" 17-Nov-17 0 display "waiting" 17-Nov-17 16-Nov-17 display "done" Thank you!
  16. L

    VBA to check if a folder name contains a specific word

    Hello, I have a file structure like: a main folder\many sub folders\excel files. What i need to do is to loop through all sub folders and if a sub folder name has "waiting" as part of its name, then open all excel files in it. can someone please help me with this line of code, the underlined...
  17. J

    VBA, OLE - Excel is waiting for another application

    I have a macro that iterates through several rows, sending cell values to another program (MathCAD). The other program processes that input, and then excel gets results back from the other program and inserts them into the worksheet. This had been working fine for some small test batches (100...
  18. O

    VBA Help

    Hi- So I'm using VBA to complete a form in Internet Explorer. Within the form, I enter text in one box(Store Number), then text in another(Qty per Store), then I click a button. The problem is the image is clicked before the text is entered, so I get an error telling me to enter a "Store...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top