Import currency formatting into a textbox - possible?

[Andrew-Mark]

Is it possible to use a command button to import a price from my worksheet into a textbox on my userform AND keep it formatted as accounting/currency?

The code I have written is bringing in the correct figure but is ignoring the formatting within the cell it's reading.

Sorry I am new to VBA and am not sure if this is possible at all.

If you need a file uploading then please ask. Haven't done it to begin with as I am not too sure what needs switching off before doing so.

Please feel free to ask any questions.

Andrew