Hi,

I have a userform with many text boxes. in Date textbox I want to
write a date like

25 Aug 07 and when I press enter then the date convert to 25 August
2007 in userform. and also it show in worksheet like 25 august 2007.

I am not much experienced in Excel VBA but I am learning.... pls
help me about the procedure for the above problem.

Thanks in advance.

Shahzad
Madinah