View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Vaughan Michael Vaughan is offline
external usenet poster
 
Posts: 71
Default Qn: Date Format in TextBox in UserForm?

Hello Everyone,

I have a userform that when initialized, loads up data from another sheet.
Three of the TextBoxes are dates. It loads it fine, but when it displays
the dates in the TextBox, it is different than what I set the Format in the
actual Cells. I have formatted the cells to a format of: 08/11/04, but
when it loads it in the TextBox, it looks like: 8/11/2004. Is there a
format code I can put to make it look just like the cell???

Thanks.. mv