Hi DanB,

You can use the

Formula:

VBA 


function "UserForm_IsLoaded" to check if a specific userform is loaded or not. Here's an example code:

1. If
   Formula:

   UserForm_IsLoaded 

   ("UserForm1") Then
   1. 'Do something with UserForm1 controls
   Else
   1. 'UserForm1 is not loaded
   End If

In the above code, replace "UserForm1" with the name of the userform you want to check. If the userform is loaded, the code inside the "If" block will be executed, otherwise the code inside the "Else" block will be executed.

Hope this helps! Let me know if you need further assistance.