doevents

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

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

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

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

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

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