Hi
Is there a way to prevent duplicates being added to array, when the values come from an input box.
The VBA code loops through a certain number of times to allow the array to be filled with the values from the input box.
How do I check after each value is inputted, to ensure that it doesn't already exist in the array?
TIA
Is there a way to prevent duplicates being added to array, when the values come from an input box.
The VBA code loops through a certain number of times to allow the array to be filled with the values from the input box.
How do I check after each value is inputted, to ensure that it doesn't already exist in the array?
TIA