|
Date Formating using VB Vlookup
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. |
Date Formating using VB Vlookup
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. |
| All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com