Dear Sam Mathai Chacko
On target! It worked very well.
The quotes rules is a little confuse and I never read anything about
it in Excel books.
Thanks a lot.
Nathan
On 22 jan, 17:16, Sam Mathai Chacko samde...@gmail.com wrote:
Nathan,
The REAL problem is as I mentioned in using the quotes.
Mr NOORAIN ANSARI
Congratulations. It works very well.
See alternative solution at Sam Mathai Chacko reply.
Thanks a lot.
On 22 jan, 14:20, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Nathan,
Problem #1 is that your MainProcedure has strLeter as the parameter name,
but you test for
Check if your macro is disable
ALT + T M S
And enable all macros
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alogon
Sent: Jan/Sat/2012 04:05
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Why my Excel
Hi
Save your file in xlsm or xls format
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alogon
Sent: Jan/Sat/2012 04:05
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Why my Excel procedure disappears?
Hello Excel
It's about adding single quotes.
Check http://www.excelfox.com/forum/f2/excel-application-onkey-parameter-285/
Regards,
Sam Mathai Chacko
On Sun, Jan 22, 2012 at 2:16 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Hi
Save your file in xlsm or xls format
-Original Message-
From:
Dear Nathan,
Problem #1 is that your MainProcedure has strLeter as the parameter name,
but you test for strLetra. strLetra would always be an empty string, So no
output, making it appear MainProcedure never gets called.
Quick Fix: change
Sub MainProcedure(strLeter As String)
to
Sub
Nathan,
The REAL problem is as I mentioned in using the quotes. And if the
intent was just to show a message, you could remove the IF statement
also. Look at the simple lines of code below.
Sub UsedShortCutKey()
Application.OnKey ^+a, 'MainProcedure a'
Application.OnKey ^+b,