Help needed on How to loop through numbers split with a comma in form text box.

The code below doesn't seem to work when trying to see if numbers entered into a form text box match the integer from a whole number entered into a cell on the worksheet. For example, if I enter 8 into cell E7 and enter 1,4,6 into the userform text box, I want the code to be able to Loop through numbers 1-8 one at a time and see if they match any of the numbers in the userform textbox. If that number matches then the shape inserted on the worksheet will be a different color with that number inside the shape than the rest of the numbers. So using the above, shapes 1,4,6 will be green and shapes 2,3,5,7,8 will be blue. Thanks....

Please Login or Register  to view this content.

I tried this one but it gives me an object error at the underlined part.

Please Login or Register  to view this content.