Excel zoom tool that reflects changes while typing

[Formula11]

I'm looking for a zoom tool which allows me to see the changes in the zoom item while I'm typing.
I envisage highlighting one or more cells, clicking a macro button and then having a magnified image which allows me to (1) keep editing and also (2) shows the changes made in real time.
Has anyone seen anything like this?

These links are useful but none have what I'm looking for exactly.
- https://excel.tips.net/T003114_Magnifying_Only_the_Current_Cell.html
- VBA Express : Excel - Zoom in on sheet when a specific range is selected
- Creating a Zoom Box in Excel – Bacon Bits
- https://www.mrexcel.com/forum/excel...xcel-magnifying-glass-zoom-entire-screen.html

 

[My Aswer Is This]

Excel zoom feature will zoom the entire sheet not just a selection range.

Is that what your wanting to just Zoom a certain range which you select?

 

[Formula11]

Just a selection.
Typically one cell, sometimes up to 4 cells.

 

[Michael M]

The 2nd link you provided does just that...lets you keep editing AND shows the changes...BUT...the code as supplied only applies to cell A2, it can be modified to other ranges though

 

[Formula11]

The 2nd link you provided does just that...lets you keep editing AND shows the changes...BUT...the code as supplied only applies to cell A2, it can be modified to other ranges though

But this magnifies the whole sheet.

 

[Michael M]

Yep.....sure does and Excel won't let you do it any other way !!!
It's the whole sheet or nothing !

BUT
what does it matter, if once you move away from that range, the sheet goes back to normal ??

 

[My Aswer Is This]

From the way I read the script in the second link it Zooms the entire sheet not just a particular Range like the user is asking for.

 

[My Aswer Is This]

Would increasing the font size work for you. We can write a script to increase font size for selection.

 

[Michael M]

You can't zoom a range !
But when zoom is activated the selection remains the focus.

 

[Formula11]

@My Answer Is This, post #8:
Increasing the font size may be useful but one the examples in the original post had this in mind.