Excel for Mac, VBA, MsgBox Command

Anonymous
2018-04-17T00:40:34+00:00

An example of the code I wrote

Sub mesbox()

If MsgBox("Are you ready?", vbYesNo + vbDefaultButton1 + vbQuestion, "Question") = vbYes Then

MsgBox "Yes"

Else

MsgBox "No"

End If

End Sub

Default button is always YES which is the second one, whether I put vbDefaultButton1 or vbDefaultButton2.

vbQuestion does not work either, there is not Question Mark icon in the Message Box.

A bug or me?

Thank you for reply.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-04-20T16:24:51+00:00

    I tested and can confirm your observations.

    To alert the Excel team to these issues, click the Smile button in Excel.

    Report each issue separately.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-04-17T11:36:11+00:00

    Yes, it is Excel for Mac

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. OssieMac 48,001 Reputation points Volunteer Moderator
    2018-04-17T10:57:27+00:00

    Works fine on a PC (including default button) so I assume it is a problem with the Mac.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments