Qn: Date Format in TextBox in UserForm?

  • Thread starter Thread starter Michael Vaughan
  • Start date Start date
M

Michael Vaughan

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
 
Load the cell text not value. i.e.

TextBox1.Text = Range("a1").Text

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top