Can I have "Shift-Click" or "Ctrl-Click" Code on Form List?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
There are only 2 click events and one of them you don't want to use. In
order to reserve future multi-select I would abandon any key-press events
also. I would try a set of Option buttons and let the list click event read
the option setting and then run a particular macro on whichever option is
True. It would also provide a visual of which macro just ran.

Mike F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top