MACRO - Count items in column and display the result

do you really need macro for what you are doing
sounds like a countif formula would do the job

if you just hide the helper countif table and pop up form with labels pointing those cells

that is fine
can you work with helper table?
would just make it easier to code

Try this macro

Sub status()
'
' Status Macro
    Dim status As String
    Dim J As Integer
    
    For J = 2 To 8
        status = status & Range("l" & J).Value & " = " & Range("M" & J).Value & vbNewLine
             
    Next J
    
    MsgBox status
    

End Sub

ps with the countif formula maybe extend it to read the whole column if data set is changing
=COUNTIF($G:$G,L2)

Sorry Its not working It shows only '=' nothing else. I have copy pasted the Macro in another MACRO? Is any prob in that? Also I have used columns till Z. This code is working fine for sample data but not working there boss...Pls help

that is why i asked if it can work with the helper table which has the countif calculations on the sheet itself

Try Version 2

Sub StatusV2()
    
   Dim Count, lRow, Closed, failed, pending, waiting, resolving, assigned, validation As Integer
   
   Count = 2
   lRow = Range("G65536").End(xlUp).Row
   
    For Count = 2 To lRow
    Select Case Range("G" & Count)
        Case "Closed"
        Closed = Closed + 1
        
        Case "Failed"
        failed = failed + 1
        
        Case "Pending"
        pending = pending + 1
        
        Case "Waiting"
        waiting = waiting + 1
        
        Case "Resolving"
        resolving = resolving + 1
        
        Case "Assigned"
        assigned = assigned + 1
        
        Case "Validation"
        validation = validation + 1
        
    End Select
    
    Next Count
    
    MsgBox ("Closed = " & Closed & vbNewLine & "Failed = " & failed & vbNewLine & "Pending = " & pending & vbNewLine & "waiting = " & waiting & vbNewLine _
            & "resolving = " & resolving & vbNewLine & "assigned = " & assigned & vbNewLine & "validation = " & validation & vbNewLine)
    
    
End Sub

problem with this code is that status is static

are you running V2?

v2 does not need any data in J to N to run
runs purely on column G