how to get count of multiple sheet's value

[emmr]

Hello All,
how i can get the count of "Apple", "Ball", "Cat" from multiple sheet, these information are available at the column of "H" of every sheets.
how i can get this through formula as well as VBA code...
TIA

[jindon]

VBA

Please Login or Register  to view this content.

[emmr]

jindon thanks for your reply, if you help me in my excel file then it will be more helpful for me,
tnx

[jindon]

For the form attached.

Please Login or Register  to view this content.

[emmr]

thanks a lot sir "jindon"
now its working well
is it possible to show the value on worksheet
B1 for Apple
B2 for Ball
B3 for Cat
Tia

[jindon]

To a standard code module.

Please Login or Register  to view this content.

[emmr]

tnx a lot sir