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 H...

excel

Haytham Amairah

Silver Contributor

Jul 31, 2018

Please show us the code located inside the Worksheet_Activate event to figure out the problem!

Shashikant Koti

Copper Contributor

Jul 31, 2018

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 If

End Sub

******************************************

Forum Discussion

Excel 2016 Help window pops up automatically when I call msgbox in VBA