Do Loop

How To Exit A Do Or For Loop Using An API Call

This post is going to show you how you can exit a for or do loop in VBA using an API call. API calls use the power of the Windows operating system to do your wishes. Here we are using the “GetAsyncKeyState” API function: Insert the following code in a common module. Click in the […]

Continue Reading

How To Restart A VBA Loop Counter

This is related to an interesting question I received from an individual, and this processing example may help someone. Basically we are conducting a 10 day clinical study on a group of patients. We want to store the results of the finding in a database and reset the study counter when a result comes back […]

Continue Reading