Help with fitting text in textbox
 

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

Help with fitting text in textbox
 

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