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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

userform textbox returns changeable date 4
Date showing as numbers in Textbox on Userform 2
Userform textbox string to header causes unwanted double spacing 4
Access Dateadd function question.. 0
restrict textbox on userform to mm/yyyy 1
VB Date Format 8
Userform Textbox to Worksheet Textbox 1
Date on UserForm? 5

Back
Top