Regional settings, can they be over-ridden within a project

Here's the point where it dies, well it doesn't die, but it doesn't format either.

Please Login or Register  to view this content.

is there a way to do this that is "region free"?

Wow this hurts.

From this

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.

and I can't get it to work

I don't know if it is significant or intentional but in the first bit of code you were assigning to MissionBegin.Text and in the second you are assigning to MissionBegin.Value.

They are on a UserForm

My problem was that this didn't work

Please Login or Register  to view this content.

not sure what made me try this:

Please Login or Register  to view this content.

But now it works... I have to add in a check to kick out null readings or it crashes tho

Please Login or Register  to view this content.

Thanks to both of you for your help, I'm afraid this nightmare is just starting.

Originally Posted by ffffloyd

I don't know if it is significant or intentional but in the first bit of code you were assigning to MissionBegin.Text and in the second you are assigning to MissionBegin.Value.

LOL I've been grasping at straws for a few hours on this one.. finally got it tho.

Dern picky beta testers actually expect the thing to work...

@shg

I honestly had no clue.

I'm sure you've heard the theory about 10,000 chimpanzees and 10,000 typewriters...

well, that's me when I'm coding...


Bang on the keyboard till the screen fills up then hit compile...

...eventually it'll work. Right?

well... as it turned out. It works on my machine, but still Kacks on the first regional setting I tried....

Please Login or Register  to view this content.

When set to Danish, instead of a formatted time, I get the core number and the Runtime Error '6' "Overflow" at the format line

MissionBegin is a TextBox pulling data from a cell on the worksheet that was set by a button... nm here is the code.

Please Login or Register  to view this content.

and a combination of lack of sleep and Noob leaves me unable to answer your question better than that.

I'll remedy the first part now, and maybe I'll understand better tomorrow.

Thank you yet again for your help