How to get the current cell position in VBA (eq. Row(), col() in F

Is there any way to know the Row and Col position when user select a cell? so I can, MsgBox( "You are in ROW "+. ... excel object (such as ActiveCell.??? ) 2.

www.pcreview.co.uk