Record Keystrokes With Macro Recorder
 

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

Thanks.

-Minitman



On Wed, 31 Mar 2004 11:25:04 -0500, "Tom Ogilvy"
wrote:

In Excel VBA help
--
Regards,
Tom Ogilvy

"Minitman" wrote in message
.. .
Hey Tom,

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

-Minitman



On Tue, 30 Mar 2004 08:28:43 -0500, "Tom Ogilvy"
wrote:

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" wrote in message
.. .
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

On Mon, 29 Mar 2004 21:06:27 -0500, "Tom Ogilvy"
wrote:

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