Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Anyone can tell me how to catch the clicked cell's location name?

  Asked By: Tracey    Date: Dec 07    Category: MS Office    Views: 534
  


I want to catch the active cell's location and show it with msgbox.
eg: when I click the cell A1, the message box with a string"A1" will
pop up

Anyone can tell me how to catch the clicked cell's location name?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Alyssa Campbell     Answered On: Dec 07

Activecell.Address...........................

 
Answer #2    Answered By: Shelia Wells     Answered On: Dec 07

Try This

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "You just changed " & Target.Address
End Sub

 




Tagged: