date format user form

[amado]

i created user form but when I search in userform date not get right date
please help

 

[amado]

screen shot for date

 

[mikerickson]

The Format function will convert a date into a string

TextBox1.Text = Format(Date, "dd mmm. yyyy")

 

[amado]

The Format function will convert a date into a string

TextBox1.Text = Format(Date, "dd mmm. yyyy")

not working , when i write date in vba user form saved in data sheet with right format
but when use search button all data is fine but data write as strange text

 

[amado]

Hello again

I've created an Excel User Form which requires a date to be entered (dd/mm/yy). On entering the date in to the form it show correctly when the data is added to the Excel worksheet .

But When the textbox calls the information from the spreadsheet it converts to number not date format

any help please

Many Thanks

 

[dmt32]

But When the textbox calls the information from the spreadsheet it converts to number not date format

Hi
when returning data from worksheet to userform textbox use the Range.Text property - this will return what you see in the cell rather than its underlying value

example

TextBox1.Value = Range("A1").Text

Dave

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Excel User Form - Date format problem

Cross-posted at https://www.mrexcel.com/board/threads/date-format-user-form.1207643/ Hello I've created an Excel User Form which requires a date to be entered (dd/mm/yy). On entering the date in to the form it show correctlys when the data is added to the Excel worksheet . But When...

www.excelforum.com

Excel User Form - how to date format from the spreadsheet

enter image description hereI've created an Excel User Form which requires a date to be entered (dd/mm/yy). On entering the date in to the form it show correctly when the data is added to the Excel

stackoverflow.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.