Dan,

Set the AutoSize property to True.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Badtaste2k" wrote in message
news:GFAZa.9202$2g.7268@fed1read05...
Hi, could someone help me figure out how to make text fit within
a textbox
which has a set size? Basically I need the text to adjust it's
size in order
to fit the entire length of the string within a textbox on a
userform. The
textbox size is constant but the length and font of the text is
variable.
Any help would be greatly appretiated.

Dan Butler