Setting Date Format for a Text Box in a User Form

[garbfink]

Hi All,

I've been struggling with this for a while now and can't believe how hard it is!. I've searched on this site and on others to get some clarification but to no avail.

It's pretty simple really. I have a user form which contains a tex box for a user to input the date I want the format to be dd/mm/yyyy but can't find out how to set the format of the text box to this.

Please can someone give me a bit of guidence or link me to a good rescource if missed it in the search.

Thanks in advance.

G

 

[xld]

how would i distibute this control?

http://www.fontstuff.com/mailbag/qvba01.htm

 

[IluvXcel]

Hi garbfink,

Long time you posted this problem, and today I too was having the same issue of day and month getting interchanged in Excel. May be this would help you/ others having similar problem.

I used a Date variable in my code and used that to populate the date data from the text box:

Dim tmpDate as Date

tmpDate=Format(CDate(TextBox1.Text), "dd/mm/yyyy")

Used the "tmpDate" variable to fill the excel's date column from the code. Earlier, I was plainly using the TextBox to fill the date column in the Excel sheet, which did not work correctly, even though I set the Excel column's date format property to dd/mm/yyyy format.

Hope this helps.

Bye.