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]

Mike,

I did a quick search for the QueryClose event and it looks like this will do the job perfectly. It even covers the problem I had with someone clicking on the X to close the form, which I asked about in another thread. I couldn't do it via the Functions using Lib "user32" since I'm using a Mac.

Thanks Mike!