LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How can I detect that an excel cell has been clicked

I have a vb.net app which includes an excel sheet. I need to detect when a
cell has been clicked but there does not appear to be an appropriate event to
handle.

So far I have handled the "XLSheet.SelectionChange" event to achieve my
requirements BUT if the cell in question is ALREADY selected, clicking on it
will not raise the above event. I have to click elsewhere so that the
selection changes, the result being that data is added to the worksheet in
the "wrong" cell.

Am I missing something that should be really obvious?

I am using vb.net express (2008) and Office 2007 (interop).



 
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
VB ; How do I detect a Comment in a cell rdwj Excel Discussion (Misc queries) 5 June 4th 08 09:17 PM
HOW DO I GET AN X IN A CELL IN EXCEL TO COME & GO WHEN CLICKED carbetboy Excel Discussion (Misc queries) 3 March 22nd 08 11:21 PM
How to detect characters in cell? Eric Excel Discussion (Misc queries) 1 November 10th 07 02:02 PM
Can I format a cell to fill red when clicked with mouse (Excel)? mike.wilson Excel Worksheet Functions 4 May 2nd 05 08:01 AM
Is there a function to detect changes in any given cell? Detecting Cell Value Changes Excel Worksheet Functions 1 January 2nd 05 11:16 PM


All times are GMT +1. The time now is 01:28 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"