Solved: UF countif in range

[Emoncada]

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

[magelan]

Pretty impressive post count. Do you code much?

pseudocode
for each varcell in Sheets("Complete").usedrange.cells
    if the variable i want to count is there
       count ++
next
lblunits.caption = count

[Bob Phillips]

[VBA]lblUnits.caption = Application.Countif(Worksheets("Complete").Columns("G"), "value")[/VBA]

[Emoncada]

Hey XLD i am getting Run-time error '438'
Object doesn't support this property or method

Any ideas why?

[Emoncada]

Nevermind I had a typo. That Worked XLD

[Emoncada]

I noticed a problem now with this.
I am getting a 1 value even when no the value is not located.
How can I have it show a 0 when not found?

[Emoncada]

Nevermind I found the problem