Annoying date format problem

[sharky12345]

Guys,

I have created a workbook for my organisation which has a substantial number of computers across a large amount of buildings, all connected by a Server.

The people using the workbook are required to enter the date into a textbox, (on a userform), and that is transferred to the worksheet where various calculations are made determined by the month, (identified by a formula). In order to ensure the date is entered on the sheet correctly, whatever way the employee enters it into the textbox, I have written the following code;

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Value = Format(TextBox1.Value, "dd mmmm yyyy")
End Sub

The problem is that, only on certain machines, some employees are getting a debug message relating to the textbox which I believe is somehow linked to a missing dll file within the system32 folder.

There is no way I can determine which computer is affected in advance and our IT Dept can't resolve it easily, so - is it possible to set a code that would format the range concerned, (in this case A8:A6996), to the correct date format before the workbook is closed?

If there is a way then I'm not sure if that would give the same error message - any ideas anyone?

 

[jvanbonn]

You could always force them to enter the dates in the correct format by using three textboxes. One each for the Day, Year, & Month.

 

[sharky12345]

I thought of that, but then thought this would have been easier - how wrong I was!