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

[Legacy 103420]

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:

RichardGreene asked on March 11, 2011

If you initiate the "shrink to fit" command in a cell and then "wrap text" the shrink to fit is "greyed" and does not appear operational or function.

I'm trying to fix the size of a cell and have the text wrap and shrink to fit to stay within the confines of the hard coded cell size.

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 check that the text is overflow in the cell? I'm totally newbie about programming. I try to write pseudo code for auto fitting by changing font size:

Read the dimensions of the selected cell
Calculate the area
Set font size according to the calculated area
Is text overflow? Yes: Set more small
Is text overflow? Yes: Set more small
Is text overflow? Yes: Set more small
Is text overflow? No
The end

Who can try to write so that? It will be great because I face the same problem for years! Why doesn't Microsoft solve that I couldn't understand.

Thanks for your supports.