Array to find TextBox.Value

[blarkin]

What I have is an Array to find and highlight all of the Cells on a Spreadsheet that = a TextBox.Value on a userform. What I would like is for it to find “like” Textbox.Value ie: myArr = Array(“*TextBox1.Value*”) so if TextBox1.value = goof or goof ball both are added to the array to be highlighted on the Spreadsheet.

Please Login or Register  to view this content.

[shg]

Maybe like this:

Please Login or Register  to view this content.

[snb]

or:

Please Login or Register  to view this content.

[blarkin]

Thanks for the help. I adjusted my code to

Please Login or Register  to view this content.

and it works as needed