Copying Cells on Enter
 

Hi. I'm new to this VBA thing as a co-worker recently left and I was bestowed
his workload. Joy to the World! Oh well it is a chance to learn....

I need to take data from Cells B8 & C8, and copy them into J8 & K8 upon the
user hiting the enter button.

I know this can be done, I'm just lost trying to jump in the middle.

Thanks in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200708/1

Copying Cells on Enter
 

Do you want to do this every time the user hits the enter button, or only
when they make a change in cells B8 or C8, or some other frequency?
Dale

--
Email address is not valid.
Please reply to newsgroup only.


"RebekahK20_pontiac via OfficeKB.com" wrote:

Hi. I'm new to this VBA thing as a co-worker recently left and I was bestowed
his workload. Joy to the World! Oh well it is a chance to learn....

I need to take data from Cells B8 & C8, and copy them into J8 & K8 upon the
user hiting the enter button.

I know this can be done, I'm just lost trying to jump in the middle.

Thanks in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200708/1

Copying Cells on Enter
 

Everytime the user is in those cells and hits enter or tab persay. It will
actually be for any cell in the Column B or C starting at Row 8...

Dale Fye wrote:
Do you want to do this every time the user hits the enter button, or only
when they make a change in cells B8 or C8, or some other frequency?
Dale

Hi. I'm new to this VBA thing as a co-worker recently left and I was bestowed
his workload. Joy to the World! Oh well it is a chance to learn....
[quoted text clipped - 5 lines]

Thanks in advance.

--
Message posted via http://www.officekb.com