| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to determine current cursor position? | Excel Worksheet Functions | |||
| How do you set cursor position at current date in macro? | Excel Worksheet Functions | |||
| Current cell position | Excel Worksheet Functions | |||
| Position of CellCursor on Screen (absolute position) | Excel Programming | |||
| how do I get the current cursor position in a spreedsheet | Excel Programming | |||
Linear Mode
