Date Format in userform textbox is different from excel worksheet?

**z-eighty2** · 06-30-2013, 06:28 AM

Hello Everyone...

I have a UserForm where I pull data from worksheet to this Userform text boxes. In these Userform text boxes there is textbox for "Date"

When my data is transfered from worksheet to these textboxes...the text box of date in Userform show different date format.

I want Userform text boxes should show same Date format as it is in excel worksheet.

For example in my worksheet Date formate is like " 01-January-2013"....When data is transfered to userform textbox ...its should show same date fomate.

Please help..

thank you.

**AndyLitch** · 06-30-2013, 06:32 AM

VBA uses the American style date format exclusively while Excel has local settings.

You need something like Me.TextBox1.text = format(Range("A11").value, "ddd dd mmm yyy")