Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CHR( ) request
Hi again,
If CHR(13) is the representation of the ENTER key, what would it be for Alt F11 ?? Thanks to all! Best regards, Bony Pony |
#2
|
|||
|
|||
CHR$() returns codes for printable characters. The function keys, arrow keys,
Ins, Del, Shift, Ctrl, Alt, etc don't produce printable characters. Why do you need this information? Are you trying to detect that ALT+F11 was pressed? If so, look at OnKey in Help. On Mon, 7 Mar 2005 11:28:15 -0800, "Bony Pony" wrote: Hi again, If CHR(13) is the representation of the ENTER key, what would it be for Alt F11 ?? Thanks to all! Best regards, Bony Pony |
#3
|
|||
|
|||
Hi and thank you for your reply.
Basically, I have a macro using activecell.codename. For some reason, it requires that the VB editor be open before it picks up the codename value. What I want to do, is invoke Alt F11 from the code to open the VBE and then again to close it after the macro has run. Any ideas? Best regards, Robert -----Original Message----- CHR$() returns codes for printable characters. The function keys, arrow keys, Ins, Del, Shift, Ctrl, Alt, etc don't produce printable characters. Why do you need this information? Are you trying to detect that ALT+F11 was pressed? If so, look at OnKey in Help. On Mon, 7 Mar 2005 11:28:15 -0800, "Bony Pony" wrote: Hi again, If CHR(13) is the representation of the ENTER key, what would it be for Alt F11 ?? Thanks to all! Best regards, Bony Pony . |
#4
|
|||
|
|||
Hmmm.... That syntax, activecell.codename, seems strange to me. When I type
this in the immediate window ? activecell.codename I get an error, "object doesn't support this property or method". Did you mean ActiveSheet.CodeName? If so, why this syntax? Is your macro creating or modifying code? On Mon, 7 Mar 2005 12:13:10 -0800, "Bony Pony" wrote: Hi and thank you for your reply. Basically, I have a macro using activecell.codename. For some reason, it requires that the VB editor be open before it picks up the codename value. What I want to do, is invoke Alt F11 from the code to open the VBE and then again to close it after the macro has run. Any ideas? Best regards, Robert -----Original Message----- CHR$() returns codes for printable characters. The function keys, arrow keys, Ins, Del, Shift, Ctrl, Alt, etc don't produce printable characters. Why do you need this information? Are you trying to detect that ALT+F11 was pressed? If so, look at OnKey in Help. On Mon, 7 Mar 2005 11:28:15 -0800, "Bony Pony" wrote: Hi again, If CHR(13) is the representation of the ENTER key, what would it be for Alt F11 ?? Thanks to all! Best regards, Bony Pony . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar-Task Pane 2nd request | Excel Discussion (Misc queries) | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
Another Date Formula Request | Excel Worksheet Functions | |||
Importing XML data from http request | Excel Discussion (Misc queries) | |||
trendline - request power --> get linear | Excel Worksheet Functions |