asked on 7/22/2015

Excel 2010 VBA disabling Enter key on message box

I've noticed that the following code will disable the Enter keys in Excel, but not in a message box. So if I presented a user with a message box and a choice of Yes or No, I can't prevent them from hitting Enter to choose the default button. Why is that?

Application.OnKey "~", ""
Application.OnKey "{Enter}", ""

Visual Basic Classic Microsoft Excel VBA

Last Comment

Martin Liss

8/6/2015

Martin Liss

7/22/2015

Do you want to make "No" the default?

Martin Liss

7/22/2015

If so

MsgBox "Your message", vbYesNo + vbDefaultButton2

Davisro

7/22/2015

ASKER

I did that. What I don't understand is why Application.OnKey doesn't apply to message boxes. So it will disable the Enter key in the application, but not in the message box

Martin Liss

7/22/2015

Most likely because a MsgBox is modal and so other code can't run while the MsgBox is open. A userform that looks like a MsgBox could be substituted and probably the OnKey code could be used there. Are you interested in something like that?

ASKER CERTIFIED SOLUTION

Martin Liss

7/22/2015

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Martin Liss

8/6/2015

I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014