Hi all,
I'm hoping what I'm after is quite straight forward.
I have a userform that has a TextBox and a command button on it.
When the userform loads up, it runs a small bit of code from a module that pulls in text from a text file stored on my C drive into the TextBox.
What I'd then like to do, is perform a search on the text that's just been pulled into the TextBox for key words and count how many times those words appear, with the results being in a message box or a label.
It's the search and count that I'm struggling with as I'm not sure where to begin with it.
I'm hoping what I'm after is quite straight forward.
I have a userform that has a TextBox and a command button on it.
When the userform loads up, it runs a small bit of code from a module that pulls in text from a text file stored on my C drive into the TextBox.
What I'd then like to do, is perform a search on the text that's just been pulled into the TextBox for key words and count how many times those words appear, with the results being in a message box or a label.
It's the search and count that I'm struggling with as I'm not sure where to begin with it.