Rob,

I have had the same thing. The only way I have been able to get round
it is to specify the format in VBa as follows

eg = Format(Date,"dd-mmm-yyyy")

I have used the "mmm" as if I use a 2 digit month it may still revert
to taking it as an american format ie 09/01/2006 becomes September
anyway, but doesn't happen from 09-Jan-2006

Not sure if there are other cures

Steve

Hi,

I am trying to use a Data Form in XL that is opened by a simple
macro/vb script attatched to a button.

This appears to work fine until a date is entered. We are using UK
date format of DD/MM YYYY hh:mm and when we enter the record it changes
it to the American format of MM//DD/YYY hh:mm.

If I open the data form without using the button then the date is
entered correctly. I know you will say dont use the form but trust me
I need to with some of the people who enter data for me.

Any ideas please?

Rob




--
BRABUS

Some of the people who use the non-USA date formats have suggested this:

Option Explicit
Sub testme()
Application.CommandBars.FindControl(ID:=860).Execu te
End Sub



BRABUS wrote:

Hi,

I am trying to use a Data Form in XL that is opened by a simple
macro/vb script attatched to a button.

This appears to work fine until a date is entered. We are using UK
date format of DD/MM YYYY hh:mm and when we enter the record it changes
it to the American format of MM//DD/YYY hh:mm.

If I open the data form without using the button then the date is
entered correctly. I know you will say dont use the form but trust me
I need to with some of the people who enter data for me.

Any ideas please?

Rob

--
BRABUS

--

Dave Peterson