| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merged cells/Fitting text | Setting up and Configuration of Excel | |||
| Fitting text into a cell problem. Please help! | Excel Discussion (Misc queries) | |||
| Textbox and multiline text | Excel Worksheet Functions | |||
| Fitting text in designated columns/rows | Excel Discussion (Misc queries) | |||
| Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
Hybrid Mode
