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