MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting a Text Box on a User Form


Posted by Kurt on July 26, 2000 8:11 AM

Hello Ryan,

Well, lo and behold I can get my numbers into this one form finally. Next question - How do I control the appearance(format) of the numbers on the text box on the User Form?

Thanks,

Kurt


Posted by Celia on July 29, 0100 5:36 PM


Kurt
Go to the text box Properties list and change the Font property to what you want.
Celia

Posted by Ivan Moala on July 30, 0100 9:39 PM


Kurt
Also look up Format command if you wish to
apply different formats to the Textbox Text
eg Format(Textbox1.text, "MM/DD/YY")

etc

ivan