Hi,

I would like to write a macro that popps up a message box showing the
current cell address when I press the down or up key to move down or up
a column. Do you have any idea about how to make this? Or would you
show me your code doing it? Thank you in advance.

David

In Tools, Options, View, if you select Formula Bar the current address
shows in the Name Box.



cyberdude Wrote:
Hi,

I would like to write a macro that popps up a message box showing the
current cell address when I press the down or up key to move down or
up
a column. Do you have any idea about how to make this? Or would you
show me your code doing it? Thank you in advance.

David


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=490507