2nd Updating Cell with VBA?

[Greg777]

Hello,

Whenever cell A1 has a new value, it is recorded in column K. I would like the VBA code to do the same for cell A2 & column L.

Here is the VBA code that I have used for cell A1:

Please Login or Register  to view this content.

I've attached 2 files.
The file that ends with an 'a' is works as expected.
The file ending in 'b' attempts to do the same thing, but twice, acting on two cells at once and gives an error. I'd like to get this to work, in file 'b'.

Thanks for any help!

Greg

[TMS]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[TMS]

You can't have two Worksheet Change Events. You need to combine the code into one module.

Test which cell has been changed at the beginning of the code and use If or Select Case to execute the appropriate code for that cell.


Regards, TMS

[TMS]

It would look something like this:

Please Login or Register  to view this content.

Regards, TMS

[Greg777]

It is no longer returning an error, but there is no 2nd value in column L. I've attached a 3rd workbook where Cell A4 can be updated, changing the values in A1 & B1. Maybe there it is lacking the ability to register the change to cells A1 & A2? If I directly change the value of the cells, they will give output individually, but of course that is not sufficient. I'd stuck on this one.

[Greg777]

OK. Looks like this one isn't possible in Excel. Closing thread.