Count values on worksheet & show in Listbox on worksheet

[ipbr21054]

I would like to count specific values on my worksheet & show them in the worksheet Listbox.

Some info for you.

Worksheet name is MCVIN
The column where the values are is always column E
The first row of values start at row 5
The values to search for are AFRICA, CBR, TIGER & ZZR
The worksheet Listbox is called ListBox1

Please advise.

Listbox should then show something like this
AFRICA 7
CBR 4
TIGER 12
ZZR 8


The Listbox i assume will just update itself as more values are added without the need to use command button ?

Have a nice day

 

[ipbr21054]

Just a thought that it doesnt have to be a Listbox.

Maybe have a code in cells t5o shows count value for AFRICA cell Z2 for CBR etc etc

So it would be like this
Cell Y1 text would be AFRICA the code would then be in cell Z1 to show counted value
Cell Y2 text would be CBR "" Z2 ""
Cell Y3 text would be TIGER "" Z3 ""
Cell Y4 text would be ZZR "" Z4 ""