Date Fomat and VBA

[k209310]

Is ther any way to automatically insert a carachter when user enters certain info in to a text box. ie for a date a user could enter 12 and then a / would automatically appear.

This would save the user having to worry about the date format.

Im not too sure if this can be done in VBA. I have seen it done in javascript.

 

[Andrew Poulsom]

This works, but the user must enter a leading zero if the day or month is less than 10.

Private Sub TextBox1_Change()
    If Len(TextBox1.Text) = 2 Then
        TextBox1.Text = TextBox1.Text & "/"
    ElseIf Len(TextBox1.Text) = 5 Then
        TextBox1.Text = TextBox1.Text & "/"
    End If
End Sub