change font size

  1. L

    VBA Brainstorming to Overcome Autofitting Problems! (Using Wrap text + Shrink to fit at the same time)

    Hi guys, I cannot select "Wrap text" and "Shrink to fit" at the same time. My english is poor and I copied from someone's similar question: :biggrin: I don't know VBA limits. If you are good at VBA can you explain my questions? Can VBA macro read the dimensions of the cell? And can we...
    • Legacy 103420
    • Thread
    • autofitting change font size shrink to fit
    • Replies: 0
    • Forum: Excel Questions
  2. L

    Fitting Text in Cell with Changing Font Size (VBA macro to change font size according to Length of Text)

    As can be seen below I need to change font size depending on length of text. I'm complete newbie about VBA macros. I ask for learning also. How to write codes to set if the length of cell is 0-49 set font size 26 if the length of cell is 50-99 set font size 22 if the length of cell is 100-149...
    • Legacy 103420
    • Thread
    • change font size fitting
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top