Key shortcut????

O

OldManEd

Is there a shortcut key for copying data in the field immediately above? I'm
doing a lot of data entry and most but not all have a common zip code. Would
like to save a few keystrokes.
Ed
 
A

AngelT

Good Morning Douglas,

I have just read your little help in regards to the "Ctrl+Apostrophe"
shortcut key (for copying data from field above) on the Community forum.
This post is the closest I've located thus far to my very question. Hope
you can help. :c)

I have used the Sendkeys in the past and all was good, until the 2000
upgrades. I've read other postings and see this not a suggested means for
accomplishing the simplistic automation I am hoping to acquire. I do a LOT
of data entry, thus automating my form fields is a great asset for me.

I currently have a "Showlast" macro, which obviously uses the sendkeys
function with the "Ctrl+Apostrophe" option. Sometimes it works and sometimes
it doesn't. When it doesn't, if I go in and out of the field a few times, it
eventually picks up. What a pain! ;c) Anyway.....
How would you best suggest I substitute this very same function for it to be
more stable? And am I correct in using this macro on the "On Enter" format?

Thank you soooo much for your help.

Tracy
 
D

Douglas J. Steele

I'd suggest using VBA rather than a macro, and simply referring to the cell
by name.
 
Top