Thanks all for the responses, I haven't tried your solution Harold, but
Bob, your solution works great. I have one question regarding your
solution though. Say I wanted to reverse the logic. I wanted to put
the text box value in a sheet as a number. I know how to do this with
Curreny = Ccur(TextBox1.value), how do I do this to convert this to a
number format.

Thanks
Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=385678