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

M

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
 
D

Dave F

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

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top