Textbox format with date

[cnu nagula]

Dear friends,

please help me,

i need a code for textbox1, which should format for date input only "dd/mm/yyy", and the number input is like 19012011 after entering this, the textbox should convert this after pressing TAB key or clicking in another box to 19/01/2011 for excel 2007. please help in this regard

thanks

 

[Yahya]

try this way

Private Sub TextBox1_AfterUpdate()
TextBox1.Value = Format(TextBox1.Text, "##/##/####")
End Sub

but the number must be entered with 8 digits
like your example 19012011

 

[cnu nagula]

Thank you, its working,

but, the textbox is accepting more than 8 digits, it should be accept for only 8 digits.

 

[cnu nagula]

i got its solution, in textbox properties, MaxLengh is set to 8 charecters