Identifying Active Cell when navigating within a WorkSheet

Posted on 2013-10-17
Medium Priority
Last Modified: 2013-10-25
I have a very nice WS that is used to input data by novice users.  Is there a way to make the cell where they have tabbed or moved to (it is a protected sheet so movement is restricted to only those cells that are protected for change) appear different (i.e. color, border, etc.)?  This would be helpful because as someone navigates the cells now, it's not always easy to tell which cell you are in based on black on black.

I've mocked up a sample for you to look at.

Password is pass

Thank you in advance,

Question by:Bright01
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39579305
Using a thin border on those cells will improve visibility of selected cell.
LVL 35

Accepted Solution

[ fanpages ] earned 2000 total points
ID: 39579503

I have added Conditional Formatting to the worksheet, starting at cell [A1]:

I have also added this code to the worksheet code module:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Open in new window

Attached is an updated workbook to demonstrate the changes.


LVL 35

Expert Comment

by:[ fanpages ]
ID: 39579563
...or there is this approach from "Excel MVP" Jan Karel Pieterse (of JKP Application Development Services):

[ http://www.jkp-ads.com/download.asp#FollowCellPointer ]
FollowCellPointer.zip (12 September 2010, downloaded: 7721 times) Version 1.0 build 007.

A small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Does not change your formatting.
Download link:
[ http://www.jkp-ads.com/downloadscript.asp?filename=followcellpointer.zip ]
LVL 33

Expert Comment

by:Paul Sauvé
ID: 39581052
If you select the View tab and check the Headings box, you see exactly what cell you're in in the upper left-hand corner!

Author Closing Comment

ID: 39599775

The conditional formatting approach worked very well....thank you!  The add in with the two lines was very hard to "eliminate".  Not sure I understand how to "turn it off" but I closed everything out and rebooted and the two arrows went away.

Thanks again.....sorry for the delay.


Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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.

Join & Write a Comment

With the emergence of Office 365 as a superior email communication platform, many organizations have started switching over to it.  After migrating to Office 365, sometimes users, as well as organizations, will have to import PST files to Office 36…
Though there are a few manual ways to import PST files to Office 365 , third-party PST to Office 365 import tools are preferred over them due to various reasons.  Consequently, many tools or services are available for the same. Here, we pick the to…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question