Help with fitting text in textbox

  • Thread starter Thread starter Badtaste2k
  • Start date Start date
B

Badtaste2k

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
(e-mail address removed)
 
Dan,

Set the AutoSize property to True.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top