• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formatting the contents of a userform textbox.

dan_l

Active Member
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 ?
 
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
 
Back
Top