Button to count how many value of textbox1 are there in column A in sheet1

Hello,

I just want to count how many value of textbox1 are there in column A in sheet1 and display it result in messagebox.

For example:

In Sheet1: There are 3 kevin

If i type kevin in textbox1 and press the button, messagebox will pop up "3 kevin"

Thanks in advance gurus!
I've attached my file.