Text box in form

[raw]

Hi guys

I have a text box in a user form that take is linked to sheet1! G3

But G3 had the formula that works out the prices from different sheets and show the answer. I can only seem to use the text box once it shows the number but Deletes the formula and just leaves the figure in the cell G3 I just need the text box as a display box?

Also i can not seem to get the text box to display £ and the 0 on the end of pence e.g. 123.1 and it should be £123.10

Thanks for your help