how to display contents of cell A2 if A3 becomes activated

[luv2glyd]

If I have some text that cell A2 contains, is it possible once I scroll to cell A3 to show the contents of A2 in cell A4, then after scrolling away to some other cell, not display anything in cell A4?

Thank you.

[davesexcel]

This appears to work.

Please Login or Register  to view this content.

[luv2glyd]

Perfect! Thank you.

I actualy have a long row of these. What do you think would be the simplest way to write the code for this?

So for example, if I have cells A2:X2 that contain different text, and I wanted to show contents of A2 if A3 is activated in A4, contents of B2 if B3 is activated in B4, contents of F2 if F3 is activated in F4, and so on. Same thing as before, just a number of cells in a row.

Thank you.

[davesexcel]

See the Edited Code, see if it works for you

[luv2glyd]

Cool, that works. I was looking for the contents to be shown one by one, though, so that once you scroll to the right/left of a particular cell, the contents get elliminated in the cell that you scrolled away from. In other words - show the contents one by one. Right now if I scroll to the right/left, I see the contents that appeared reamain "appeared".......

[davesexcel]

I know.....I can't think of what to do about it since row 3 is the target row

[shg]

Maybe ...

Please Login or Register  to view this content.

[luv2glyd]

OK, that works well. Thank you. For some reason, with either code, the paste function becomes disabled. If I was to highlite any cell and copy it, then scroll to another cell and try to paste it, I'm not able to do it. Any way around that with this?

[shg]

Also flushes the undo buffer -- things that should make you reluctant to use VBA unless you really need it.

[luv2glyd]

Right, no big deal in this case. This will work for what I'm trying to do. Thank you both.