Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why doesn't Excel 2007 record charting and office art macro code? | Excel Discussion (Misc queries) | |||
Code to Test Condition and Save Record to Excel | Excel Programming | |||
Record Macro - Record custom user actions | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Code to Update a Record | Excel Programming |