I am using the following code
UserForm3.TextBox8 = Application.WorksheetFunction.VLookup(Ext,
Columns("A:F"), 6, False)
It is bringing in the date but the date is in the number format. Ex
37396 = 5/20/02.

I have TextBox8.Value = Format(TextBox8.Value, "mm/dd/yy") under the
actual field on the form, but it doesn't seem to work.

Can someone please help with this formating issue.

UserForm3.TextBox8 = Format(Application.WorksheetFunction.VLookup( _
Ext,Columns("A:F"), 6, False),"mm/dd/yy")

--
Regards,
Tom Ogilvy


"Samantha" wrote in message
om...
I am using the following code
UserForm3.TextBox8 = Application.WorksheetFunction.VLookup(Ext,
Columns("A:F"), 6, False)
It is bringing in the date but the date is in the number format. Ex
37396 = 5/20/02.

I have TextBox8.Value = Format(TextBox8.Value, "mm/dd/yy") under the
actual field on the form, but it doesn't seem to work.

Can someone please help with this formating issue.