VBA Code Change Event Code When 2 cells are selected

Looking for a Private Sub Worksheet_Change(ByVal Target As Range) code to concatenate cell J, K, E and F cells when both J6 and K6 are selected. The cells start in J6 and K6. When both J6 and K6 are selected, I would like a VBA code to concatenate J6, K6, E6 and F6 in cell L6 (here is the formula =IF(OR(J6="",K6=""),"",I6&" "&J6 &" "&K6&" - "&E6&" "&" "&F6 I have but looking for a VBA code to accomplish task).

When either J6 or K6 is selected, the code should not concatenate until both cells (J and K) are selected. I would also like a Clear Contents function to clear L6 (or L7, L100, L80 or L13) contents when either J or K cell is deleted. For example, if K value is deleted, the Clear Contents should clean J and L cells contents.

Thanks.

Just a lil bit extension of ajryan's ..

Please Login or Register  to view this content.

Can you please upload a sample file with provided code..

Originally Posted by bjnockle

when both J6 and K6 are selected. The cells start in J6 and K6. When both J6 and K6 are selected, ....

Do you mean both cell's are populated.. or selected..

in case of selection.. code is working fine..

Originally Posted by bjnockle

when both J6 and K6 are populated or values entered, J6 pulls values. Thanks

Please Login or Register  to view this content.

With your query, the technical term "Worksheet_Change" is only to create confusion...
Use provided code

Try this one..

Please Login or Register  to view this content.