Master reset code bug - stumped again

  • Thread starter Thread starter peter.thompson
  • Start date Start date
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
PROBLEM DISPLAYING USERFORM 1
Loop back to Case vbNo '#2 7
Check Box macro 1
Rounding Ranges 1
Goto function 9
data from combo box in userform to spreasheet???? URGENT!! 3
Print Macro 5

Back
Top