ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I have "Shift-Click" or "Ctrl-Click" Code on Form List? (https://www.excelbanter.com/excel-programming/391196-can-i-have-shift-click-ctrl-click-code-form-list.html)

MikeZz

Can I have "Shift-Click" or "Ctrl-Click" Code on Form List?
 
Hi,
I have a form with 4 lists.

I want to be able to run one routine if a person left-clicks on an item in
list 1,
or run another routine if the either Shift/Ctrl/Right click on the item. I
just need one alternate clicking routine and don't really care what it is
(but don't want double-click). Right now the boxes are all single-select may
want the option to have it multi-select in the future.

Essentially I want to have one type of click reset all the other list boxes
and if I use the special-click, it acts like a drill-down feature
narrowing/shrinking the lists in all the other boxes.

Thanks,
MikeZz


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com