I have generated a UserForm and on the form are several TextBoxes.
Part of the function of the UserForm is to copy the contents of a cell
into 1 of the TextBoxes.
The contents of the cell is the date which in the cell is in the
01/11/06 format.
Problem is that when it copies it into the TextBox it ends up in a
11/01/06 format.
How do I change the format of the TextBox??


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=526696