Could anyone help with the code for the following event? Thanks.

Count Occurrences
· Write code to count the occurrences of "txtEntry2" in "txtEntry1" when the user clicks the button "cmdCount". Display the result in the label "lblResult". For example, entries of

"This is some text this is" and "is"

would cause the following text to appear in the label "lblResult" when the user presses the button "cmdCount".

"Occurrences Found : 4"

· Clear the result display.

· The count should NOT be case-sensitive.

· Remove leading spaces from the text before reversing it.

· Check that the user has entered at least one character in both text boxes.

· Save the project.

· Run several tests.

Hints:
use Mid and Instr functions among others