Create a Global variable set it to false. Call the event and then loop until the Global variable is true (set it to true at the end of the event; remember to put in DoEvents). Once the variable is true set it to false (to reset the program for the next event) and exit the loop.
Yehuda
|