Master reset code bug - stumped again

P

peter.thompson

Am using the following code to reset all userforms - the issue is that
after the sub has executed the 'hour glass' remains displayed until I
move the mouse.

Private Sub CommandButton37_click()
YesNo = MsgBox("This action will clear all benefits data, do you want
to continue?", vbYesNo + vbCritical, "Caution!")
Select Case YesNo
Case vbYes

Case vbNo

Exit Sub
End Select

Load UserForm3
UserForm3.Reset_Click
Unload UserForm3

Load UserForm4
UserForm4.Reset_Click
Unload UserForm4

Load UserForm5
UserForm5.Reset_Click
Unload UserForm5

End sub

Any ideas on how to fix this is appreciated

Cheers

Peter (new to VBA)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unload UserForms 9
Loop back to Case vbNo '#2 7
CheckBox Help 6
Excel process still shows in TaskManager 7
PROBLEM DISPLAYING USERFORM 1
Help with code restricting TextBox entry 6
UserForm MsgBox problems 6
Check Box macro 1

Top