"John A Grandy" wrote in message
...
how to capture shift-double-click or ctrl-double-click ?

Hi John,

As far as I know, you can't. Since the Shift and Ctrl keys are used to
modify the way cells are selected with the mouse (and keyboard) on a
worksheet, the BeforeDoubleClick event doesn't even fire if you hold down
either of these keys while double-clicking a cell.

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