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 "+....+"COL"+...)

thanks so much

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

maybe
MsgBox ActiveCell.Address

--


Gary


"Johan2000" wrote in message
...
Is there any way to know the Row and Col position
when user select a cell? so I can,
MsgBox( "You are in ROW "+....+"COL"+...)

thanks so much

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

Thanks so much Mr Gary K.

MsgBox ActiveCell.row & ", " & ActiveCell.col

Will also work. Can you tell me :
1. Is there any doc or help file that I can download to explain all the
excel object (such as ActiveCell.??? )
2. What is the easiest way to get back to this post? since the page number
will keep changing...
3. How to read all the post offline ? (like reading doc or pdf...)

Thank again! Have a nice day!
Johan2000




"Gary Keramidas" wrote:

maybe
MsgBox ActiveCell.Address

--


Gary


"Johan2000" wrote in message
...
Is there any way to know the Row and Col position
when user select a cell? so I can,
MsgBox( "You are in ROW "+....+"COL"+...)

thanks so much

ActiveCell.Address row and column
 

Actually the correct form (the one that works) is

MsgBox ActiveCell.Row & ", " & ActiveCell.Column

Cheers


On Thursday, October 26, 2006 11:59 PM Johan200 wrote:

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

thanks so much


On Friday, October 27, 2006 12:16 AM Gary Keramidas wrote:

maybe
MsgBox ActiveCell.Address

--


Gary


On Sunday, October 29, 2006 3:33 AM Johan200 wrote:

Thanks so much Mr Gary K.

MsgBox ActiveCell.row & ", " & ActiveCell.col

Will also work. Can you tell me :
1. Is there any doc or help file that I can download to explain all the
excel object (such as ActiveCell.??? )
2. What is the easiest way to get back to this post? since the page number
will keep changing...
3. How to read all the post offline ? (like reading doc or pdf...)

Thank again! Have a nice day!
Johan2000




"Gary Keramidas" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
JustCode Visual Studio Development Add-In by Telerik
http://www.eggheadcafe.com/tutorials...y-telerik.aspx