However, on Range level only an “Activate” event is fired (SelectionChange). Note that on every level two events are raised when switching to another object.

You may keep this in mind when reading on. Here we discuss how to use DoEvents function in Excel using VBA code along with practical examples and downloadable excel template.The conceptual model in the figure above presents an overview of the five levels and their Activate/Deactivate events. Try applying the code in a huge and big set of coding, there we will see the actual implementation and use.Once we complete the code, save the file in macro-enabled excel format to avoid losing code.We can see the change in the process while working on the other work simultaneously.And that we will either resume the files once the code is completely run or crash the file on multiple clicks. If we do anything without applying DoEvents, then there is a major possibility that the code makes the system and file freezed.

The code stops when we write or change the cell for a moment and we don’t get notified.It overwrites the worksheet or workbook when we switch between the different worksheets or workbook.Using DoEvents doesn’t stop us doing the work we want when the code is running.We can work on any tool or file in the background while the VBA code will be running in parallel.As we can see, while we tried to click on Stop, the code didn’t stop. Step 8: If we remove the DoEvents and run the code, we will be not able to do anything until the code gets completes its process. The numbers reached at 4348 only which is quite less than the limit we set. For demonstration, I have selected the cells B1 and C1. We will see, we can do anything even when the code is running. Step 7: And then run the code by pressing F5 key. Step 6: And at last we will put DoEvents at the end of For loop condition. Step 5: Now select the range where we want to see the output. Step 8: To get full control of the code, apply DoEvents after the loop conditions as shown below. We will see, the code has completed by printing the numbers from 1 to 20000 but we couldn’t stop it. Step 7: Now run the code by clicking on the Play button located below the menu bar.

Let’s say the range of cells is A1 to A5. Step 6: Once we define the range of numbers, we will select the range of cells where we will see the changes in numbers which we chose above. Here we are taking the range 1 to 2000 in defined variable A. Step 5: Consider the range of a number of your choice which can be seen getting implemented. Step 4: Now open a For-Next loop where we will put the conditions. Purpose of considering the data type as Long is because we will be taking any length of data we want which is not possible if we consider Integer. Step 3: Now define a variable in any name with data types Long.

Vb6 form events sequence