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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Incidentally, the notes at the link indicate that the macro is slow, but it
works instantaneously for me....

Dave
 
Back
Top