Excel Userforms Textbox query
 

Hi

I have a textbox which uses a date value in a cell from the
spreadsheet. At the moment it shows the value of the cell as m/d/yy how
do I get it to view dd/mm/yy?


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

Excel Userforms Textbox query
 

Try using a textbox from the drawing toolbar rather than from the control
toolbox toolbar.

--
Regards,
Tom Ogilvy

"funkymonkUK"
wrote in message
...

Hi

I have a textbox which uses a date value in a cell from the
spreadsheet. At the moment it shows the value of the cell as m/d/yy how
do I get it to view dd/mm/yy?


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

Excel Userforms Textbox query
 

unfortunately I cannot as I am using a userform.


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

Excel Userforms Textbox query
 

unfortunately I cannot as I am using a userform

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

Excel Userforms Textbox query
 

Now I see that in the subject. another example of why it is best to include
all pertinent information in the body.

Private Sub Textbox1_AfterUpdate()
Textbox1.Text = format(Textbox1.Text,"dd/mm/yy")
End Sub

You might have to experiment with other textbox events to see which works
best.

--
Regards,
Tom Ogilvy


"funkymonkUK"
wrote in message
...

unfortunately I cannot as I am using a userform.


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