Add more text to existing cell through VBA text box 1

[2ks]

I wish to add more text to an existing cell, that already has some info in.

I want to create a item tracking history according to ref number.

I can find by ref, offset to column etc but then I need the newly input txt to Set a new line in the cell (just like Alt and Enter if manually updating a cell to get a new line) and then transpose the new txt at the end.

How do I get VBA to do that bit?

Thanks

 

[PHV]

A starting point:
yourCell.Value = yourCell.Value & vbLf & "new line of text"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886