Key shortcut????

  • Thread starter Thread starter OldManEd
  • Start date Start date
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
 
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
 
I'd suggest using VBA rather than a macro, and simply referring to the cell
by name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top