MS Excel for Mac 2011 - VB Ver 14.0 - Escape Key capture

[TAPS_MikeDion]

Hi all,

Does anyone know if VB key capture works with Excel for Mac 2011?

I have tried several different methods to capture the ESC key being pressed and I can't seem to get it to do anything.

The last simple thing I tried was:
Application.OnKey "{ESC}", "EscapeKeyPressed"

inside the UserForm_Initialize sub,

and then just did a short:
Sub EscapeKeyPressed()
Msgbox "Escape key pressed"
End Sub

to see if that would work (unless I'm doing that wrong) and nothing happens.

Thanks.

 

[TAPS_MikeDion]

Bump.

 

[RoryA]

It won't work while the form is active (in Windows either), if that's what you're trying to do?

 

[TAPS_MikeDion]

Hi Rory,

Thanks for the reply. I was trying to capture it so the user can't escape out, because hitting escape actually closes the form and jumps back to the previous form.

 

[RoryA]

Did you set a Cancel button?

 

[TAPS_MikeDion]

I'm not 100% sure what you mean by "setting" a Cancel button. I would call myself a VBA novice.

 

[RoryA]

Do you have a button on the form to close it, whose Cancel property is set to True? If not, pressing Esc shouldn't do anything at all.

 

[TAPS_MikeDion]

Oh, lol. Yes, there's a button to close and exit the form and it's Cancel property IS set to True.

I just changed it to False and now the escape key does nothing. Thanks!

 

[mikerickson]

Have you tried writing to the QueryClose event to see if you can capture the user exiting the wrong way?

 

[TAPS_MikeDion]

Hi Mike,

Long time no...type. LOL

No, I'm not sure exactly how to do that.