Prevent duplicates in array from input box entries

[Bilbo1161]

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

 

[Fluff]

Why not use a Dictionary rather than an array?

 

[Bilbo1161]

Not sure what the dictionary function is.
The entries actually relate to the names of the sheets in the workbook. The array is then used to print our the selected sheets.
Can the dictionary do this?

 

[Fluff]

Yes, it can

Excel VBA Dictionary - A Complete Guide - Excel Macro Mastery

This post contains everything you need to know about using the VBA Dictionary. There are tons of code examples including a real world application.

excelmacromastery.com

 

[Bilbo1161]

Thanks, I'll look into the syntax for it

 

[Fluff]

Ok, any problems just shout