And just to add to Ron's code:
Tools|macro|macros...
Click on Test (or Test2) and then click Options
That's where you can assign the shortcut key.
then Ok, then Cancel your way out.
=========
And this may not work, but you may want to try this:
Tools|options|Edit
Check Move selection after enter (and make it move Down)
If I recall, ctrl-M was a way to send an enter key to some old DOS programs (and
modem programs, too).
(But I have no idea if this'll work with your scanner. Ctrl-m didn't work when
I typed it manually--but it'll only take a moment to find out.)
Ron de Bruin wrote:
Try this
Sub test()
ActiveCell(2).Select
End Sub
Or this one
Sub test2()
ActiveCell.Offset(1, 0).Select
End Sub
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Dag Adamson" wrote in message m...
Hello-
My bar code scanner is sending an ASCII control-M to excel. I was
wondering how I might record a macro to get it to move the cursor
down.
I tried using the macro tool - but it merely places the cursor back to
the cell during the recording.
I imagine this is foolishly simple to do... any help would be greatly
appreciated.
Thanks
Dag
Please post and email
--
Dave Peterson