Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reset button code for Radio Buttons | Excel Discussion (Misc queries) | |||
Master reset code -stumped | Excel Programming | |||
Code Halt - prevents reset of the AutomationSecurity level | Excel Programming | |||
Reset Used Range, Debra Dalgliesh's code | Excel Programming | |||
How do I reset the LastUsed cell reference from code. | Excel Programming |