Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Alex Meyer   on Dec 18 In MS Office Category.

  
Question Answered By: Darwishi Massri   on Dec 18

I did scan the discussion - just thought I'd toss in a different idea.

But I did miss the "already selected" part. This can be an annoyance with
selection events. A benefit of my suggestion is that you can click  on a
different cell in the same row - you're not limited to Column A.

As far as I know there is no way to get a selection change  event, or any
other event, by clicking  on the already-selected cell. However, you do get
a "before double click" event if you double click a cell. Perhaps that's an
alternative.

The converse problem is that you sometimes get too many selection change
events. Every time you move the focus, you're going to get one, and you
need to handle it.

In general, I like to avoid selection change events, because they can be a
pain. But sometimes, they're either necessary, or simply the best approach.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on possible to change Protected Sheet error message? Or get search suggestion and latest updates.


Tagged: