Macro does not trigger when selecting with Shift key on LB
I have a macro to trigger whenever a selection is made in the list box. The macro get triggered all the time EXCEPT when I select the items with Shift key.
I have the macro enabled on the onchange and onSelect. If I select an item with just a clik on an item, or using CNTRL key to multi select the macro is triggered, but if I use Shift key to select more than one item, macro does get called.
Any idea what I am missing?
I have added the excel file and the qvw file for reference.
Having the exact same problem. I even put in MsgBox at different places in the macro to see the progress; and with all other selection methods it goes through just fine. However, with Shift+select the macro is not even triggered.
Am searching all QV KBs etc to see what I can find.
After much searching; the kb, the reference materials, the Dev I and II handbooks, and the blog I could not find any other entries talking about why Shift-select behaves differently from ctrl-select or drag-select. I settled for creating a layout condition since my macro was setting a show, no show value. I checked the OnSelect, OnChange, and OnInput on both the Field event and the Variable event that was a simple count distinct of the field current selections.
As far as I can tell QV does not have any information on this problem.
I have the same problem. I tried to get around it by creating a variable set to the distinct count of field selection and attaching a trigger to the change of the variables. The variables correctly changes, but the trigger attached to it doesn't fire on Shift+click selection (although it does fire correctly on other selection types).
I also tried the document event trigger OnAnySelect. That doesn't fire either.
