I think in your IsInCollection function, it makes sense to call exit function as soon as the value is found. The function will then run on average 50% faster (if you prefer the math analysis, it goes from O(n) to O(n/2). In practice, even faster as you don't need to have the WasFound variable on the stack, and you no longer need to run the final exiting the searching loop implies it was not found. I respect that in teaching, sometimes lots of verbosity is valuable too, so this is just a different approach.
I think in your IsInCollection function, it makes sense to call exit function as soon as the value is found. The function will then run on average 50% faster (if you prefer the math analysis, it goes from O(n) to O(n/2). In practice, even faster as you don't need to have the WasFound variable on the stack, and you no longer need to run the final exiting the searching loop implies it was not found. I respect that in teaching, sometimes lots of verbosity is valuable too, so this is just a different approach.
Really good stuff, concise and well structured, really helped me with my project, thanks!
Fine, useful tutorials, please some more vba videos, thank you, Cheers
You're a master!!!!!
I cannot get passed the "Compile Error: Expected user-defined type, not project. "
Great Work .. Really Thank You