I have a userform that I would like to figure out how to do the following.
I want to be able to get a count of how many times a value is found in a range and display it in the userform.

So in the userform I have a lblticket.caption which has a value.
I want to look at the "Complete" sheet Range(G:G) and return a count and display it in lblUnits.caption