If x = (value in array name specified in textbox1.value) then

**ks100** · 10-14-2014, 01:08 PM

How do I get VBA to do:

Please Login or Register  to view this content.

?

**Speshul** · 10-14-2014, 01:15 PM

What is X? A variable? An array? String?
You say an array named in textbox1, an array meaning what? Textboxes contain strings sure but I'm not sure about arrays

Can you expand on this question a little more?

**ks100** · 10-14-2014, 01:23 PM

Originally Posted by Speshul

What is X? A variable? An array? String?
You say an array named in textbox1, an array meaning what? Textboxes contain strings sure but I'm not sure about arrays

Can you expand on this question a little more?

There are a series of text boxes on a userform. Ten to be exact.

You can type of up to 10 names of people you want to search for projects assigned to them.

I want it so that if you type the name of a person in the text boxes, it will check if X ( a string) contains one of those values.

I also want it so that I can name arrays. For example, if James is over 10 employees. I want to be able to enter James' name in one of the text boxes, and have it pull all 10 names from the "James" array, and check to see if X is = to any of them.