Auto Add/Append Value on the Same Cell

Good day everyone...

Please help me how to make it...
Example in Column A5:A20 (triggered by macro)
if i enter value in A5 like "test" then cell value is "test"
if i enter again on the same cell(A5) with a value like "123" and hit enter key
then A5 will append previous cell value "test" + current value "123" = output("test;123")
if ever i need to add again on the same cell(A5) like "123"
then A5 value become "test;123;123"

Try

Please Login or Register  to view this content.

Thanks for quick reply KOKOSEK & Phuocam, both are working...
can you move the output to the next column instead.
it seems complicated if on the same cell (i'm sorry for that), because when i tried to press F2(edit)
it duplicated all previous value too.
how if target value as entry point and column B as exit point
so if ever i need to edit only column B will be affected.

KOKOSEK, can you make the output without ";" on last entry,
on first entry like "test" = "test"
second entry like "123" = "test;123"
it will add ";" only before the new data entered
and so on...

Phuocam, can you make it the same way too?
your code is working great...
only i cannot press delete because it will add ";" on last part
can you make target value as entry point and next column as exit point

KOKOSEK, it's working but...
can you make it work between column of entry & exit point only
because i have a lot of data to be entered.
if ever i need something to edit from output column, i need also to edit the "backup" sheet
if not it will capture the data from backup again...

see attached file

check attached file for some changes sir...

KOKOSEK, I just followed the trail you made and some adjustment and it works the way i want...


Replaced all the same code from:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

Thank you...