Forum Discussion

Frank Drucker's avatar
Frank Drucker
Copper Contributor
Apr 25, 2021

Using If in Visual Basic to change cell's Zoom based on text color

I have Excel 2016 on a Windows laptop.

I want to use the If function in Visual Basic to change a cell's zoom based on the text color of that cell.

 

For example. If the cell has red text, the zoom should be to the selection. If the text color is black the zoom should be at 100%.

 

Using a macro, the cell's color is shown as a "with" statement. For example, a red text would be                

"With Selection.Font
.Color = -16776961
.TintAndShade = 0
End With

 

Don't know how I would phrase this in Visual Basic.

 

Thanks,

Frank Drucker

1 Reply

  • Frank Drucker's avatar
    Frank Drucker
    Copper Contributor
    Well, it's been almost a month with 71 views and no replies. I guess this was just not possible.

    I appreciate everyone who looked.

    Thanks,
    Frank Drucker