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