Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
Posts: 866
Default Function to determine current cursor position?

Is there an Excel 2007 fuction where I can learn which cell a user clicks on?

For example: If the user clicks on cell 'B4', the function returns Row 4,
and can also return the Column (in this example, 'B' or '2')

Thanks in advance.

--Dan
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Function to determine current cursor position?

Hi,

Activecell.column
Activecell.row
Activecell.address

Take your pick

Mike

"Dan" wrote:

Is there an Excel 2007 fuction where I can learn which cell a user clicks on?

For example: If the user clicks on cell 'B4', the function returns Row 4,
and can also return the Column (in this example, 'B' or '2')

Thanks in advance.

--Dan

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cursor position MarkT Excel Discussion (Misc queries) 5 February 7th 07 01:25 PM
Position Cursor to same address on another tab SassyLassie Excel Worksheet Functions 0 July 14th 06 05:44 AM
How do you set cursor position at current date in macro? Tom Robertson Excel Worksheet Functions 1 May 28th 06 03:50 PM
Cursor position saziz Excel Discussion (Misc queries) 2 August 9th 05 08:19 PM
Cursor position? Marc Excel Discussion (Misc queries) 1 March 27th 05 07:09 PM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"