Forum Discussion
Excel 2016 Help window pops up automatically when I call msgbox in VBA
Excel 2016 Help window pops up automatically when I call Msgbox. I have called the Msgbox in the Worksheet_Activate function. Immediately after the Msbox is displayed, along with Msgbox, Excel 2016 Help Window also opens.
I do not want "Excel 2016 Help" window to pop automatically. Is there solution to avoid this.
8 Replies
- Please show us the code located inside the Worksheet_Activate event to figure out the problem!
Please find function attached. When worksheet is activated, I call the Msgbox. If I remove Msgbox , I don't get the Excel 2016 Help window,
**************************************
Dim MsgSW2 As Boolean
Private Sub Worksheet_Activate()
If MsgSW2 Then Exit Sub
If Range("CatchSW").Value = False Then
MsgBox "Please remember to update the data in the Section"
MsgSW2 = True
CommandButton1.Visible = True
Else
CommandButton1.Visible = False
End IfEnd Sub
******************************************
This is a strange issue!
I tried to reproduce the code on my own but the Excel 2016 help window didn't pop up!
Typically, it pops up when you press F1.
