Blacklist with Arrays

can you create a blacklist with dictionary or array? and if you query with if whether Blacklist has the value of the variable eg User, something like this

Black List (Array)
1 Apple
2 You
Etc
If Var(User) exempt Var (Blacklist)
Run Macro

Means if the user does not have the value Apple or You, the macro should be executed, if not then cancel, for example
 

Dm114

Well-known member
can you create a blacklist with dictionary or array? and if you query with if whether Blacklist has the value of the variable eg User, something like this

Black List (Array)
1 Apple
2 You
Etc
If Var(User) exempt Var (Blacklist)
Run Macro

Means if the user does not have the value Apple or You, the macro should be executed, if not then cancel, for example
Of course it's possible. Juste create such a list and then iterate it when you want to make a check.

Another much easier way would be to store these words (enclosed with a particular character, such as <word_A><word_B>...) in a string variable and test whether this variable contains the <searched _word>
 
I have an idea that I do it using arrays and integers that it checks what is in [1]... until everything went through once and I leave the integer value +1 until everything in the array has been checked
 
Top