Timer loop in one workbook disables other workbooks from being edited

Hello,

Currently, I have a userform that runs a timer upon clicking 'Start' and stops once 'Stop' is pressed. Once stopped, another userform asking for additional information about the timed session will display and be recorded onto the Excel sheet. My problem is that when the timer is running, users cannot edit other workbooks that they have open. Does anybody have another way of doing this that would allow users to edit other workbooks while this loop is running? Here is the code for it:

Please Login or Register  to view this content.

Hi mason0567,

It seems like you have two problems:
a. The problem that mehmetcik pointed out. When you open the UserForm as Modal, by definition the rest of the Excel world is locked out in this Instance of Excel until the UserForm Closes. You could access another workbook, if it were opened in a separate instance of Excel.

b. Your endless loop is a resource hog. If you add a delay in the loop, other workbooks should be able to be accessed. I was only able to access other workbooks using View > Switch Windows. See the changes in red below that added a delay:

Please Login or Register  to view this content.

The delay is for 1/4 of a second, even though your granularity is one second. The reason is to allow the application to seem responsive when you click a CommandButton.

Lewis

Awesome, thanks for the advice. It works perfectly!