Use .value when you are putting the textbox value into the cell, for
e.g.

Sheet1.Range("A1") = TextBox1.Value

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374123

Formula:
--------------------
mangesh_yadav Wrote:
Use .value when you are putting the textbox value into the cell, for
e.g.

Sheet1.Range("A1") = TextBox1.Value

Mangesh
--------------------


This seemed to work thanks Mangesh


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=374123

Hello Funkymonk,

If you have the TextBox linked to the Worksheet through the
ControlSource property, then yes, the code will display the entry in a
Currency format. You must first make the code changes for it work.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=374123