ExcelBanter - dates in userform

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - dates in userform (https://www.excelbanter.com/excel-programming/348880-dates-userform.html)

Antonov

dates in userform

hello again. The cells in my workbook are this format: Date (14/03/01 -
dd/mm/yy). When I input the date through my userform I don't get this
format. How can I correct it?
thanks again and ...
merry xmas everybody

Leith Ross[_418_]

dates in userform

Hello Antonov,

Like this...

WITH TEXTBOX1
.TEXT = FORMAT(.TEXT, \"DD/MM/YY\")
END WIT

Just change the TextBox name to the one you are using.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=49586

All times are GMT +1. The time now is 05:40 PM.