asked on

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.

Martin Liss

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

Bright01

ASKER

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.

Martin Liss

Add an ActiveX textbox control to the sheet and name it txtFloat.

Bright01

ASKER

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.

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

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.

Martin Liss

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.

Bright01

ASKER

Thanks Martin. Sometimes I get too creative for Excel..... Best to keep things simple.

Thanks for the insight.

B.

Martin Liss

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