hi i have a textbox which a user enters in a money value however when
click the ok button and submit that value to a sheet it pastes it a
text and does not put the value as £. I want it to display on the shee
as £13.99

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=37412

Hi funkymonk,

Use this code for setting the date in a cell from the userform textbox

Private Sub CommandButton1_Click()

dt = Split(TextBox1, "/")
myDt = DateValue(dt(1) & "/" & dt(0) & "/" & dt(2))
Sheet1.Range("A1").Value = myDt
Sheet1.Range("A1").NumberFormat = "dd/mm/yy"

End Sub


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

how do i use this with range a1 being a static range

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=37412

What is the cell in your case where you put the date...?
can you show your code where you put the textbox into the cell


Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37412