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?
 
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
 
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Martin LissOlder than dirtCommented:
Add an ActiveX textbox control to the sheet and name it txtFloat.
0
 
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:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.