Help with fitting text in textbox

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)
 
C

Chip Pearson

Dan,

Set the AutoSize property to True.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'automatic resize of Textbox to fit text' does not work 7
text box 5
Text box set to memo vs. Lines Coded on a report 0
Pb with textboxes font size in a UserForm 1
Textbox - Wrap text onto second line for long fields 3
Make a text box fit the value inside 4
Please help... real simple question... 3
Help with adding controls 0

Top