Count number of times a word occurs on a sheet

[captbluefin]

We would like to create a form that allows us to count the number of times a word occurs on a sheet.

The form itself would be very basic Just two fields necessary. One to input the woed of interest, and one to display how many times that word occurs on the current sheet.

A text field (lets call it txtTest)
A label or text box ( call it lblCount or txtCount)
We would like to be able to enter the name of one of the analyses we perform, "HAA" for instance in the txtTest field, and have the txtCount of lblCount field show the number of times the value in the txtTest field occurs on the entire sheet.

I've tried to copy and paste several examples found online into a cell, all to no avail.
As always, any help is greatly appreciated.

[6StringJazzer]

Why do you need to use a macro? This can be done with a simple formula.

Assuming that your data is in Sheet1.
Create a new sheet.
In A1, place the word that you want to count.
In A2, put this formula:

=COUNTIF(Sheet1!A1:Z99,"*" & A1 & "*")

where Z99 is the lower-right corner of your data.

It would also help to provide a file with a sample of your data. See yellow banner at the top.

[captbluefin]

That works for text values. Not getting correct count for numerical values.
Example sheet id attached.

[6StringJazzer]

Your example was text; you didn't mention there were numbers. If you are matching exactly the entire cell, rather than just looking for a part of a cell, it's even easier.

=COUNTIF(Sheet1!A1:B20,A1)

[captbluefin]

Perfect. Sorry for not being more clear initially. THANKYOU.

[6StringJazzer]

You're welcome! Just come back if for some reason you really need a macro solution.