Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

Note: This may not be the proper way, but it is easy to add to existing code. See here for "proper method" → Event Driven Modeless UserForms - VBA


Public ModelessFormShowing As Boolean
Public Sub WaitForModelessUserForm()
 Do While ModelessFormShowing = True
End Sub
Sub CallUF()
 ModelessFormShowing = True
 UserForm.Show vbModeless
 Call WaitForModelessUserForm
 'Continue Code
End Sub

Then just add this to exit statement of UserForm:

ModelessFormShowing = False

  • No labels