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

Date Format in TextBox in UserForm?
 

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)

"Michael Vaughan" wrote in message
...
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