Date Formating using VB Vlookup

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

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")
 
Back
Top