column header click

  • Thread starter Thread starter John A Grandy
  • Start date Start date
John A Grandy said:
how to capture a click event on a column header .... ?
Click to expand...

Hi John,

You need to trap the SelectionChange event and then check the Target
range argument to see if it refers to an entire column.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Hi John:

You are correct, and I'm not a fan of the method. Better to use the
Worksheet_DoubleClick event; it's a lot cleaner.

Regards,

Vasant.
 
John A Grandy said:
On a related note, on this forum I've noticed that, in general, people are
substituting the SelectionChange event for the missing Click event ....

.... but the selection can change via other mechanisms than clicking ....
for example, arrow keys, or tab keys ...
Click to expand...

Hi John,

Maybe it's a quirk in the way I structure my apps, but I mostly key off
the Change event, and when I do use SelectionChange it's for situations
where I don't care how the range was selected.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Vasant,

I agree, but double-clicking is a pain isn't it? We want that Click event,
so MS, please take note.

Regards

Bob
 
Back
Top