Problem mapping procedure using OnKey Method

A

Adrian

Hi,

I am using the OnKey Method to map a keyboard sequence to a procedure in
my form frmDFPanel.
However, when I run my code below, an error occurs. Can someone please help
? Thanks.


The code is as follows :

In "ThisWorkbook", the code is as follows:

"
Private Sub Workbook_Open()

'Load DFPanel
frmDFPanel.Show 0

'Mapping the keyboard ...
Application.OnKey "+{Left}", "frmDFPanel.test"

End Sub
"
In the form, frmDFPanel, the code is as follows:
"
Public Sub test()
MsgBox "Sub procedure within form activated!"
End Sub
"

The error message is as follows:
" The macro "D:\Project\DFFS.xls'!frmDFPanel.test' cannot be found! "
 
F

Frank Stone

I think the problem is in the ThisWorkbook part. the code
behind the form is in forms.(look at your project window.)
why is the code behind the form. try moving it to this
workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top