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)
 
Back
Top