Formatting the contents of a userform textbox.

[dan_l]

I can't seem to find how to do this. I've got a userform that's being used as a viewer for some data in a workbook. I'm using application.worksheetfunction.vlookup to select the data from the list. there's a date formatted cell, that only diplays the returned result in serial form.


Is there a way to specify that the output comes in in mm/dd/yy ?

 

[Hui]

Userform controls don't have a Format property for the number format as you have with cells etc on a worksheet


You can however format the control using code

eg: Label1.Caption = Application.WorksheetFunction.Text(cells(3,5).Value, "mm/dd/yy")

Change to reflect the userform control you are using