Hi,
Can anyone spot an issue with the following?
Basically, my code runs when CheckBox1 is ticked, but if there is an error in the code, the above error trapping kicks in (a message box appears and CheckBox1 is unticked). Things work as expected, but the MsgBox doesn't close when OK is first pressed - it has to be clicked twice for the window to shut.
Any ideas?
Thanks,
Matty
Can anyone spot an issue with the following?
Code:
MsgBox "Operation not possible at this time.", vbInformation, "Information"
.CheckBox1.Value = False
Basically, my code runs when CheckBox1 is ticked, but if there is an error in the code, the above error trapping kicks in (a message box appears and CheckBox1 is unticked). Things work as expected, but the MsgBox doesn't close when OK is first pressed - it has to be clicked twice for the window to shut.
Any ideas?
Thanks,
Matty
Last edited: