Hi i am looking for some assistance on how i can display the Number of times a word or phrase occurs using a user form.
Hi i am looking for some assistance on how i can display the Number of times a word or phrase occurs using a user form.
Hi
just add this to a VBA Module, or the sheet code and run it, it will check all the cells of the active sheet for a specific text and tell you how many times it occurs, not case sensitive.....
should give you what you want, if you need help just post back, someone will helpPlease Login or Register to view this content.
Please Login or Register to view this content.
.. and don't forget to have fun!
Bogdan.
mark SOLVED and Add Reputation if my answer pleases you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks