LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default vba code to record a macro

I have a friend who has paralysis of his right side. All his
keyboarding is one-handed. He would like to use a keyboard shortcut --
say ctrl-z to start recording his key strokes...say down 2 right 4 from
the ActiveCell, edit that cell. Then when he moves to the next cell the
'macro' can be invoked again. When finished the macro needs to
'disappear' to be replace the next time he runs it.

I have found most of what I need, assigning and unassigning the
shortcut keys, and the cell movement and editing is all good. - well
it works, I am after all a VBA hack :-) - but I haven't been able to
find any method that would prompt the user to enter 'anything' and have
those movements recorded other than invoking the macro recorder from
the worksheet.

Is this possible, or am I barking up the wrong tree?

Andy

 
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
Why doesn't Excel 2007 record charting and office art macro code? NOLuckMatt Excel Discussion (Misc queries) 0 August 17th 07 02:38 PM
Code to Test Condition and Save Record to Excel Ken Hudson Excel Programming 0 May 25th 05 05:32 PM
Record Macro - Record custom user actions Sal[_4_] Excel Programming 1 December 23rd 04 03:18 PM
how to count/sum by function/macro to get the number of record to do copy/paste in macro tango Excel Programming 1 October 15th 04 01:16 PM
Code to Update a Record No Name Excel Programming 1 January 29th 04 10:02 PM


All times are GMT +1. The time now is 05:17 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"