Date Format

[AndrewKent]

Hi there,

I have an ActiveX TextBox and ListBox on a worksheet that I'm having a bit of an issue with.

One of the columns the ListBox looks at (and I have linked to the TextBox) is a date column. The data in the background is in UK format, 22/06/2011, however when I view this in the ListBox (and when I load the TextBox using VBA) it populates as 6/22/2011.

The second issue I have is that when I write back to this column from the TextBox (again using VBA), if I type in "22/06/2011" when it is added to the cell, it does not recognise this as a date.

Can anymore help me out here?

Andy

 

[Jerry Sullivan]

Hi Andy,

The problem might be related to your regional settings. You can determine what your regional setting is for date with this statement:

MsgBox "The xlDateOrder value is " & Application.International(xlDateOrder)

The return value indicates:
0 = month-day-year
1 = day-month-year
2 = year-month-day

I don't have much experience with this issue, but I believe that VBA will use the regional settings unless you use some method to explicitly force it to use a different format.

This link explains a few of those methods.
http://www.mindspill.org/873

Hope this helps.