doevents

  1. T

    Anyone know a "Super DoEvents" or a way to force OLEDBConnection to update its refreshing property?

    Hi All, I've discovered recently that DoEvents doesn't yield to all events - for instance, OLEDBConnection objects do not update whilst VBA code is running when their state has been changed during a .Calculate call made from VBA, even if followed by a DoEvents loop. Aside from using scheduled...
  2. O

    How to 'update' or DoEvents for a userform being unhidden from another userform

    Hi Again Guys! I have two userforms. One is modal (modal1) and one is modeless (modeless1) - the modes may not be relevant but just in case there it is. Modal1 opens first and the user clicks on a combobox and selects a certain value to hide modal1 and show modeless1. Modeless1 then works like...
  3. Jaafar Tribak

    How to prevent a running Loop from stopping when editing the worksheet ?

    Hi all . Consider the simple code below : Private bStopMacro As Boolean Sub StartLoop() bStopMacro = False Do Range("a1") = Format(Time, "hh:mm:ss") DoEvents Loop Until bStopMacro End Sub Sub ExitLoop() bStopMacro = True End Sub The code just...
  4. M

    Backspace stops timer (but not macro?)

    Hello! I have a timer macro that runs when a workbook opens, counts down for 5 minutes. When it reaches zero, it closes without saving (to prevent users from hogging the book - shared workbooks are not appropriate in this case). All works fine - DoEvents means that users can input data whist...
  5. S

    Problem with DoEvents function

    I am trying to create a simple file that will help me time a race I am organizing. I found the attached file online (I forget where), and have modified it over time. I would like to simply be able to enter numbers into column B, and have the script record the time on the same row. The...
  6. R

    Challenge - while workbook.open running continue other excel tasks

    I'm fairly new to VBA for excel! I have an html page that I'm opening with excel. It is a very large document which takes around 3 minutes to open. After it is opened I parse the web page in excel and strip out what I need. What I would like to do is start the workbook.open and while...

Watch MrExcel Video

This Week's Hot Topics

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