In VBA sub, I set UserForm.TextBox1.Text = Format(Range("A1").Value,"0"), but the TextBox1 actually displays "12/31/1899". Cell A1 is formatted as "mm/dd/yyyy". I do the same thing on several other textboxes and it works fine, but I can't see anything different about TextBox1.
I reckon the cell actually contains text-if you change its number format does its displayed value change?
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks, JosephP. I was referring to the wrong textbox.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks