dates in userform

  • Thread starter Thread starter antonov
  • Start date Start date
A

antonov

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting a date to a cell from UserForm 2
Finding Date in an overseas format 20
Excel is changing date format incorrectly 7
VB Date Format 8
Textbox value 2
Excel 2003 Dates - Strange behaviour 2
Userform and Text Box Date 2
Date on UserForm? 5

Back
Top