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

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
Back
Top