Copy cell value with format

Hi

I am trying to move a cell value from one sheet to another without loosing its format.

This i my cell with format:

Capture.JPG

This i my cell when i am moving the cell value and adding two lines.

Capture1.JPG

How can i move the cell value and keeping the format?

Atm i am using a variable to store active cell value and adding two lines through my userform:

Please Login or Register  to view this content.