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. Leandroarb

    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

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top