Emphasizing the Active Cell

EE Pros,

I am trying to find a way in Excel to emphasize and magnify the active cell (the cell you are working in), in a worksheet (not global), or a group of cells as I enter or review data.  

An example would be, if I'm in cell C3, I would want it to magnify so while I hover over or type in a word or name, it makes it very easy to see what a user is doing.  

Make sense?

Thank you in advance.

B.
Bright01Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
I've attached an example. Select and enter text in range A2:F8 on Sheet1. The code is based on my Magical Floating ActiveX Control article. The Worksheet_SelectionChange is where you can change the range where the "expansion" shows up and how big it is.
Q-28670721.xlsm
0
Bright01Author Commented:
Martin,  

Thanks so much for the comment and the code.  When I bring up the Sheet1, I get a compile error that txtfloat is not defined.  Can you check it on your end?

Much thanks,

B.
0
Martin LissOlder than dirtCommented:
Add an ActiveX textbox control to the sheet and name it txtFloat.
0
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Bright01Author Commented:
So, it won't let me add an ActiveX Text box.  Also, I'm trying to magnify a particular cell, not a text box.  

Will that still work?

B.
0
Martin LissOlder than dirtCommented:
You are probably better off if you execute this line of code from the Immediate Window in the workbook I uploaded

sheets("Sheet1").txtfloat.visible = true

and then copy/paste the control to your new workbook.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
So, it won't let me add an ActiveX Text box.  Also, I'm trying to magnify a particular cell, not a text box.  
You can't magnify/Zoom one cell in a worksheet, only the whole sheet so what my code does is to temporarily float a textbox over the cell that's larger than the cell and has a bigger font size and still shows the cell's contents.

Will that still work?
Does my workbook work? If not you probably have a widely reported problem caused by a recent Windows update.
0
Martin LissOlder than dirtCommented:
This article describes the problem, the solution for which is

Do a search in Windows Explorer – make sure to include hidden and system files and folders – for *.exd files (note: that’s not *.exe !!) and delete any you find.
0
Bright01Author Commented:
Thanks Martin.   Sometimes I get too creative for Excel.....  Best to keep things simple.

Thanks for the insight.

B.
0
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.