What vba code equivalent to excel formula CountIf

[Flexcel22]

Hello Mr/Mrs Excel(s),

This is might be a piece of cake if I were a MVP or expert in excel but I'm not. I went around circles on the internet and couldnt find what I desired.

Here's my case.

I had a textbox which I wanted to return the COUNTIF result after pressing a CommandButton. I know in excel formula you just insert, for example, =COUNTIF(F10:F20236, "<3.1") but since i wanted to be done on a userform, I began to stress out any ways.

Please help me out.

 

[Joe4]

You can use the COUNTIF function in VBA like this:

Application.WorksheetFunction.Countif(...)

 

[PatOBrien198]

Try, in VBA, merely putting "Worksheetfunction.CountIf(Range("F10:F20236"), "<3.1")

alternate syntax could be:

worksheetfunction.countif([b16:b55],"<24")

 

[Flexcel22]

Thank you Joe4 and PatOBrien198.

Worked Perfectly

 

[Fluff]

How about

Private Sub CommandButton1_Click()

    TextBox1.Value = [COUNTIF(F10:F20236, "<3.1")]

End Sub

 

[Flexcel22]

Hello Fluff,

I have tried your code and it worked too

Thanks a lot for the tips and solutions. I really enjoy being part of this forum with many heroes.

You all save my day

 

[Fluff]

Glad we could help & thanks for the feedback