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! "
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! "