Date Format in UserForm

[Stuie]

Hey guys...

I have a userform that about a 100 people use as i made it for work, and it takes typed in data and stores it in another workbook.

in one of the columns i have it storing the data which is coded like this:

(fnd) is an integer representing the first blank row.

Please Login or Register  to view this content.

now the problem i have with this is because this is being used on loads of seperate machines some of them have the regional settings set differtently so i am getting some dates like this... 05/03/2007 12:36 and some like this 03/05/2007 <--- backwards as i need it all in uk time.

any ideas how to force this to only be entered in UK time??

[Carim]

Hi,

Adapt to your needs ...

Please Login or Register  to view this content.

[raypayette]

You could convert their local time zone (temporarily)!
Pearson

[Stuie]

Thanks for your fast replies guys...

unfortunately changing the pc times isnt an option as there are over 1000 pcs in the building and they could be using anyone of them plus would have to be requested to our admin team.

Adapt to your needs ...

Code:

Please Login or Register  to view this content.

This wouldnt leave any formula would it ??

[Carim]

Could you please clarify your question ...?
Is the formula fixing your problem or not ...?

[Stuie]

yea this works good m8... just wondered if it would enter a formula into the worksheet but it doesnt so all cool... altho it seems to be going in as US date

Edit: Scrap that m8 i changed the day and month around and it works now... cheers for your help

[Carim]

Glad it fixed your problem ...

Thanks for the feedback