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

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
>
>

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