Identifying Active Cell when navigating within a WorkSheet

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,

B.
Active-Cell.xlsm
Bright01Asked:
Who is Participating?
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.

Saqib Husain, SyedEngineerCommented:
Using a thin border on those cells will improve visibility of selected cell.
0
[ fanpages ]IT Services ConsultantCommented:
Hi,

I have added Conditional Formatting to the worksheet, starting at cell [A1]:
=AND(CELL("col",A1)=CELL("col"),CELL("row",A1)=CELL("row"))

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

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

  Target.Calculate
  
End Sub

Open in new window


Attached is an updated workbook to demonstrate the changes.

BFN,

fp.
Q-28269457.xlsm
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
[ fanpages ]IT Services ConsultantCommented:
...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 ]
0
Paul SauvéRetiredCommented:
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!
0
Bright01Author Commented:
FP,

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.

B.
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 Applications

From novice to tech pro — start learning today.