Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 273
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to record keystrokes ? Steve[_9_] Excel Discussion (Misc queries) 4 December 5th 07 02:44 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 1 February 5th 07 09:31 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 3 February 5th 07 08:22 PM
Macro to record keystrokes and not cell addresses Brian William Johnston Excel Discussion (Misc queries) 3 May 17th 06 09:27 PM
Macro recorder Fossil_Rock Excel Discussion (Misc queries) 1 July 30th 05 08:10 PM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"