Hello Forum

I have this code that split a text, and put a value in a text box,
Ex:

ABS1-EN1-FINLAND1 Split in ABS1 or EN1 or FINLAND1
I want to change it such in order to chose the column that contains the text to split, and in the column to put my result
Here is the code with the userform,