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

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

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

Hi Funkymonk,

A simple statement like this should work:
ActiveCell.Offset(0, 23).Value = TextBox5.Value
it is working for me.

Can you tell me how the user is expected to enter the date in this box.
Probably of the user is trying to enter in the dd/mm/yyyy format he
would face problems as excel cannot recognise these formats

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

Hi funkymonk,

this should solve your problem

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

So even if textbox1 has a date like 22/2/2005, excel will correctly
interprete it. But I guess the probelm will remain in dates like
5/2/2005

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