Thread: CHR( ) request
View Single Post
  #3   Report Post  
Bony Pony
 
Posts: n/a
Default

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


.