Need to test all open forms if modal.
![]()
Dim ctrl As Object For Each ctrl In VBA.UserForms If TypeOf ctrl Is MSForms.UserForm Then 'if ctrl is modal then unload ctrl else ctrl.hide End If Next ctrl
Need to test all open forms if modal.
![]()
Dim ctrl As Object For Each ctrl In VBA.UserForms If TypeOf ctrl Is MSForms.UserForm Then 'if ctrl is modal then unload ctrl else ctrl.hide End If Next ctrl
Have a look at this http://www.excelforum.com/excel-prog...-modeless.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks