Counter and a Loop

**bnevena** · 08-29-2018, 10:19 AM

Hello Fellow Forum Members,

I'm a beginner in Excel VBA and need help how to create a loop and count occurrencies of particular values. I have a list of machines and the materials they are made of.I'm interested how many machines are made of "Wood". Attached is the sample file. I have difficulty deciding how many varialbles I need (what for) and how to write the loop. I suppose that a Do until loop is a solution but I'm not getting it correctly.

Could you please give ideas how to get the result of the counter in a messagebox?

Kind regards,
Nevena

**ImranBhatti** · 08-29-2018, 10:30 AM

Originally Posted by bnevena

I have a list of machines and the materials they are made of.I'm interested how many machines are made of "Wood".

You don't need a VBA for this. This can be achieved by using builtin function "CountIF". Did you try that?

**bnevena** · 08-29-2018, 10:59 AM

Hello ImranBhatti,
I'm exercising VBA and that's why I'm searching for a way to solve this challenge with a loop and counter.

**ImranBhatti** · 08-29-2018, 11:19 AM

In cell E1 type "Steel" or "Wood" and run this code.

PHP Code:


Sub CountForMaterial()
Dim i As Integer, j As Integer

j = 0
With Sheet1
    For i = 2 To .Range("C" & Rows.Count).End(xlUp).Row
        If .Cells(i, 3) = .Cells(1, 5) Then
            j = j + 1
        End If
    Next i
End With
MsgBox j
End Sub

For further learning visit here.l

**Fluff13** · 08-29-2018, 11:29 AM

Another option

Please Login or Register  to view this content.

**ImranBhatti** · 09-01-2018, 12:51 PM

Thanks for the rep+

Counter and a Loop

LinkBack

Thread Tools

Rate This Thread

Display

Counter and a Loop

Re: Counter and a Loop

Re: Counter and a Loop

Re: Counter and a Loop

Re: Counter and a Loop

Re: Counter and a Loop

Thread Information

Users Browsing this Thread

Similar Threads

How to Reference a Loop Counter

Display a loop counter

[SOLVED] Reducing the value of a loop counter

Loop Macro with Counter

For loop counter reset

[SOLVED] Counter in a loop

How can I avoid changing a loop counter within a loop?

Bookmarks

Bookmarks

Posting Permissions