Excel 2002 : Is there any active row bar to aid data entry ?

[Mr. Low]

Dear Sir,

Can I have a light color bar at the active row to assist data entry under
Excel 2002 ?

Let consider the folowing worksheet:

A B C D E
1 A114 xxx
2 A126 xxx
________________________________
3 B135 xxx Light color bar -->
________________________________
4 B246 xxx
5 C554 xxx
6 C412 xxx
7 D412 xxx
8 F411 xxx
9 G788 xxx
10 H891 xxx
11 J663 xxx
12 M258 xxx

Can I customized a light color bar to highlight row A3: C3 when I am doing
the data entry at cell C3 ?

This bar would move up and down as I move the cursor. It also lengthen or
shorten when the cursor is move right or left.

I need this sopecial feature could assist me to readi the content in each
cell in column A correctly before data is key in at several columns to its
left.



Thanks

Low

 

[Dave F]

See here: http://www.mcgimpsey.com/excel/highlightrow.html

Dave

 

[Dave F]

Incidentally, the notes at the link indicate that the macro is slow, but it
works instantaneously for me....

Dave

 

[Mr. Low]

Thanks
--
A36B58K641

Incidentally, the notes at the link indicate that the macro is slow, but it
works instantaneously for me....

Dave