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.