View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Stone Frank Stone is offline
external usenet poster
 
Posts: 134
Default Problem mapping procedure using OnKey Method

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.
-----Original Message-----
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! "


--
Regards,
Kok Hsing
(Guoxing)


.