+ Reply to Thread
Results 1 to 2 of 2

Master reset code bug - stumped again

  1. #1
    Forum Contributor
    Join Date
    12-16-2005
    Posts
    161

    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)

  2. #2
    Forum Contributor
    Join Date
    12-16-2005
    Posts
    161
    Problem now fixed up - my induced bug!

    Peter

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1