This Excel VBA Tutorial explains, how to check the nth occurrence of any text in a range. We can create User Defined Function with VBA Code and then this function to check 1st occurrence or 2nd occurence or 3rd occurence or 4th occurence of specific text.