Record Keystrokes With Macro Recorder

[Minitman]

Greetings

How do you record keystrokes with the macro recorder?
When I tried I got the results of the keystrokes, not the keystrokes!

Anyone know of a way!

TIA

-Minitman

 

[Guest]

Not sure if this will help, but you might try looking at the Help for the SendKeys statement. That statement often doesn't work for me as it is documented to, but it might work for what you need.

 

[Tom Ogilvy]

The macro recorder doesn't record keystrokes. It translates your actions
into VBA statements.

 

[Dave Peterson]

See one response to your other post.

Please don't post separately to different groups. Either cross-post (include
all the newsgroups you need in the header and post once) or just pick a single
group and post there.

 

[Minitman]

Hey Gregg,

It does not even come up in xl2000 help.

Thanks for trying.

-Minitman

 

[Minitman]

Hey Tom,

I kinda noticed and I may have misstated what I would like to
accomplish.

Is there a way to use VBA and state, in code, which keys I would like
the code to execute (rather then use the macro recorder)?

Thanks.

-Minitman

 

[Tom Ogilvy]

Here is the first part of the Sendkeys help from xl2000

SendKeys Statement


Sends one or more keystrokes to the active window as if typed at the keyboard.

Syntax

SendKeys string[, wait]

The SendKeys statement syntax has these named arguments:

Part Description
string Required. String expression specifying the keystrokes to send.
Wait Optional. Boolean value specifying the wait mode. If False (default), control is returned to the procedure immediately after the keys are sent. If True, keystrokes must be processed before control is returned to the procedure.

 

[Minitman]

Hey Tom,

This is great! By the way, where is it located?

-Minitman

Here is the first part of the Sendkeys help from xl2000

SendKeys Statement


Sends one or more keystrokes to the active window as if typed at the keyboard.

Syntax

SendKeys string[, wait]

The SendKeys statement syntax has these named arguments:

Part Description
string Required. String expression specifying the keystrokes to send.
Wait Optional. Boolean value specifying the wait mode. If False (default), control is returned to the procedure immediately after the keys are sent. If True, keystrokes must be processed before control is returned to the procedure.

Hey Tom,

I kinda noticed and I may have misstated what I would like to
accomplish.

Is there a way to use VBA and state, in code, which keys I would like
the code to execute (rather then use the macro recorder)?

Thanks.

-Minitman

 

[Tom Ogilvy]

In Excel VBA help
--
Regards,
Tom Ogilvy

Hey Tom,

This is great! By the way, where is it located?

-Minitman

Here is the first part of the Sendkeys help from xl2000

SendKeys Statement


Sends one or more keystrokes to the active window as if typed at the keyboard.

Syntax

SendKeys string[, wait]

The SendKeys statement syntax has these named arguments:

Part Description
string Required. String expression specifying the keystrokes to send.
Wait Optional. Boolean value specifying the wait mode. If False

(default), control is returned to the procedure immediately after the keys
are sent. If True, keystrokes must be processed before control is returned
to the procedure.

 

[Minitman]

Ahhh, I was looking in Excel Help....Opps <G>

Thanks.

-Minitman

In Excel VBA help
--
Regards,
Tom Ogilvy

Hey Tom,

This is great! By the way, where is it located?

-Minitman

Here is the first part of the Sendkeys help from xl2000

SendKeys Statement


Sends one or more keystrokes to the active window as if typed at the keyboard.

Syntax

SendKeys string[, wait]

The SendKeys statement syntax has these named arguments:

Part Description
string Required. String expression specifying the keystrokes to send.
Wait Optional. Boolean value specifying the wait mode. If False

(default), control is returned to the procedure immediately after the keys
are sent. If True, keystrokes must be processed before control is returned
to the procedure.