I have a sheet within my workbook where I'm trying to do a couple related things at once that I think may be messing with each other. I am applying data validation on the fly first -- in other words, every time I click on a cell in a given range on my sheet "User Lists" it checks the header of that column, looks for that value in the header row on "User Picklists" and then if it finds it it uses the list from that page as the list for data validation on User Lists. Some of the columns need to be Multi-Select though, so once that code block runs, I have included code that I found on this page. (I also tried the code on this page with the same result.)

For the Multi-Select portion, I copied the code almost exactly from the post above (I only altered the initial If statement to match my actual use case). The difference between my sheet and the sample sheet is that the sample sheet fires the code when you select a value from the list (expected behavior), but my sheet fires it right when I click the cell. I am guessing this is because of the first code block that assigns the data validation. That code block is a necessary part of the sheet's functionality, so removing it isn't an option, but what I am looking to discover is how I can make the second half of this code (the multi select) fire only when selecting a value from the list.

Please Login or Register  to view this content.