execution

  1. C

    RE: Stopping macro execution without generating an error message....

    RE: Stopping macro execution without generating an error message.... This code displays a userform every 5 seconds t = Now() + TimeSerial(0, 0, 5) Application.OnTime t, "RepeatMSG" And the macro which displays the form: Sub RepeatMSG() Userform.Show t = Now() +...
  2. Y

    VBA to skip warning message

    Hello all, I have a very simple problem (i am sure it is), but i just can't resolve it: - I have one excel workbook that opens another workbook with VBA: Application.Workbooks.Open Filename:="C:\Users\xxx\Desktop\yyy.xlsx", UpdateLinks:=True -I need the VBA to update all the links, then copy...
  3. I

    Execution interrupted message after new code added

    Morning all, Yesterday i added the code supplied below. I also was using the worksheet after for quite some time without any errors etc. This morning when i come to use the same worksheet i see the following error message. Code execution has been interrupted. I removed the code that was...
  4. L

    Logical difficulty

    Hi, I need to understand a logic. I have services that have a lead time that can be from 1 to 30 days. as of the date that this service was issued, I need to add to its date the days of its execution period. I can not add Saturdays, Sundays and holidays. I have a table with all the days that...
  5. 5

    estimating execution time in VBA

    Hi! :) I was wondering if there is a code to ESTIMATE run time of a macro (before going through all of the loops and calculations). I already incorporated elapse time and timer but the result comes out after the total execution of the codes and hence shows how long it took place. Any help or...
  6. S

    Executing a Subroutine on a cyclical basis using time as a condition for execution

    Greetings, I am interested in building a subroutine that imports external data from using a web query on a cyclical basis, one day, one week, one month, or one quarter. I would like to know if anyone has experience in doing this and if so how might be best to structure the block of code that...
  7. R

    UserForm Data Validation

    I have a UserForm that has 43 text and combo boxes. I want to introduce some code that verifies that certain fields are completed, and in certain formats. An example is "txt_Updated". This field is required to be completed. I added the code below, but want the User to be able to either enter...
  8. H

    Macro to Copy Tab Multiple Times w/ Reference to Sequential Cells

    Hi Everyone, I have to create 79 tabs in excel using a standard template [see below], but that references sequential values in a separate worksheet. We will call the template worksheet "Template" and the worksheet that contains the reference values "Reference". I need help creating a macro to...
  9. S

    CTRL+Break Public Function

    Is there any way to write a public function that will trigger if code execution is ever cancelled by a user. For security reasons, I would like to program it in so that if the user breaks the code or if there is an error I didn't catch the program automatically brings the user to a "safe" place...
  10. O

    VBA codes slow execution?

    Why is this code executing so slow? Sub AIPlacing() Dim x As Integer Dim y As Integer Dim row As Integer Dim row2 As Integer Dim row3 As Integer Dim row4 As Integer Dim column As Integer Dim column2 As Integer Dim column3 As Integer Dim column4 As Integer Dim AIDirection As String Dim checker...
  11. T

    Execute Dynamically Named Function/Sub

    I have a list of workbooks and a related function/sub that formats the workbook and outputs some data. The list is stored in a sheet similar to the following.Book1ABCD1WrkBkFunction2Report1FmtRpt13Report2FmtRpt24Report3FmtRpt15TblMstrFmtTblMstrSheet1 I would like to be able to call/execute the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top