automatically changing font size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
turn on autosize
in VBA
range("a1").shrinktofit = true
this will keep the default font size but shrink if it is too long
 
You must log in or register to reply here.

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

Remove Hyperlinks Without Changing background shading 14
Emailing individual worksheets - problems with save as and filename/subject 0
Macro for using solver function using visual basic 0
Adjusting height of text cells 3
Command Button & Font Size 4
Label controls change apparent font size when moved up/down 3
Anyone know what size font is in general use on this forum? 5
Adjustable Font Size 6

Back
Top