column header click

[John A Grandy]

how to capture a click event on a column header .... ?

 

[Rob Bovey]

how to capture a click event on a column header .... ?

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 *

 

[Vasant Nanavati]

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.

 

[Rob Bovey]

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 ...

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 *

 

[Bob Phillips]

Vasant,

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

Regards

Bob