Thread: [Solved] Script Directory
View Single Post
 
Old 06-09-2018, 08:10 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

try
Code:
For X = LBound(d.keys) To UBound(d.keys) - 1
    cpt = d.keys()(X)
    N = Application.WorksheetFunction.CountIf(rng, d.keys()(X))
    With frmRecordUpdate.lstSelection
        .AddItem cpt
        .List(.ListCount - 1, 1) = N
    End With
    '
    '
    '
Next X

Last edited by NoSparks; 06-10-2018 at 06:25 AM.
Reply With Quote