Macro that shows a cell address when pressing the down or up key
 

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

Macro that shows a cell address when pressing the down or up key
 

put this on the sheet code page

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox ActiveCell.Address
End Sub

--


Gary


"cyberdude" wrote in message
oups.com...
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

Macro that shows a cell address when pressing the down or up key
 

Hi David,
The name box at the left of the formula bar would also show the address.

But from your question it looks like you want to activate the macro with a MsgBox
from the up down arrow keys, and that would be a disaster in my opinion, but
you could use ONKEY to trigger the macro.
http://www.mvps.org/dmcritchie/excel/whortx2k.htm#onkey
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gary Keramidas" <GKeramidasATmsn.com wrote in message ...
put this on the sheet code page

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox ActiveCell.Address
End Sub

--


Gary


"cyberdude" wrote in message
oups.com...
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