What I am trying to do is have a VB to search for a numerical listing such as in a txt file:
1.
2.
3.
4.
5.
And then copy the text between the "bullets" then place this on a userform in seperate textboxes.
such as the value between 1. and 2. would go to textbox1, the value between 2. and 3. would go to textbox2. I would like it to do this 20 times or until the value of "End of report" appears.
1.
2.
3.
4.
5.
And then copy the text between the "bullets" then place this on a userform in seperate textboxes.
such as the value between 1. and 2. would go to textbox1, the value between 2. and 3. would go to textbox2. I would like it to do this 20 times or until the value of "End of report" appears.
