automatically changing font size
 

I have a worksheet where people may enter text of various lengths. Is there a
way I can reduce the font size if the text entered is too long to be viewed
entirely in the default font size? I do not want to change the size of the
cell, or change the font size for all cells.

automatically changing font size
 

turn on autosize
in VBA
range("a1").shrinktofit = true
this will keep the default font size but shrink if it is too long


"Jared" wrote:

I have a worksheet where people may enter text of various lengths. Is there a
way I can reduce the font size if the text entered is too long to be viewed
entirely in the default font size? I do not want to change the size of the
cell, or change the font size for all cells.