<RESOLVED>find out which cell i have clicked on

[SmagO]

Hi, im doing an app in excel VBA. I need to be know what cell the user has clicked on...cant remember how do do this...help please

thanks in advance

[SmagO]

There is an event that gets called when the selection changes. It passes a range object that contains the selected cell(s)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

it works

[Spajeoly]

Yes, do like this...

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
    msgbox ActiveCell.Address, VBInformation, "Weeeeee!!!"
End Sub

And here is how I find out if a cell is one I want to use to call a procedure when clicked on, well ok, I admit it, i make buttons out of cells...<sob>

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
    If ActiveCell.Address = "$B$1" Then Call CoolNiftyAndHandyProcedure
End Sub