Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Shrink Text To Fit. Open excel and hit alt f11 to open the vba development window. See if the text will fit the in the label or command button Note that a line feed in a caption is Chr13.
The box will appear as shown below. Shrink to fit is directly below Wrap text. This is achieved by setting th efont size to 0.
Viewed 19k times 5.
Dim ActualTextWidth As Long. Dim ActualTextHeight As Long. Learn how to use shrink to fit and text orientation in a cell. Is it possible to use css to shrink text to automatically fit the size of the div.