This is a common "complaint" from Lotus users. They want the recorder to record key strokes,
such as Enter Edit mode, move to the end of the string, backspace 3 times, hit Enter, move down
to the next cell. Excel won't record that. It will record changing the value in a specific cell
to some specific new value, not the fact that you did 3 backspaces.

The OP will have to learn the equivalent VBA commands for the actions he is taking with his
keystrokes. For the above scenario, it would be

With ActiveCell
.Value = Left$(.Value, Len(.Value) - 3)
End With


On Tue, 02 Sep 2003 02:33:41 GMT, "Dean Waugh" wrote:

select ....Tools, Macro, Record New Macro

this should give you similar functionality to Lotus,

select ....Tools, Macro, Stop Recording

when finsihed,
You can then go back to Tools, Macro, Visual Basic and look at th modules to
see the actual VBA code for what you have recorded.

"tquinn" wrote in message
...
Glad to see I searched this thread. I've been trying to get Excel to
record my keystrokes while editing for a couple of years,
unsuccessfully, and nobody else seemed to know why it wouldn't work.

This is one capability of Lotus that I wish Excel had provided. It
isn't very sophisticated, but if you just want to clean up data or do
the same things to a lot of cells using a macro, a quick recorder
capability is very nice. Excel is so strong in so many areas, I'm
surprised Microsoft neglected this.

Are their any aftermarket utilities that do this?

Terry