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


--
raw
------------------------------------------------------------------------
raw's Profile: http://www.excelforum.com/member.php...o&userid=28312
View this thread: http://www.excelforum.com/showthread...hreadid=479531