Master reset code bug - stumped again
 

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)


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=498932

Master reset code bug - stumped again
 

Problem now fixed up - my induced bug!

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=498932