Counting quantity - data contained in one cell by new line

[kev2131]

Hello,



Thank you in advance to answer my question!



I'm a beginner in VBA and i'm working on some code that can help me out to count the total number of specific product from the cell, for example in column B it contained different shoes brand with quantity we sold, i want to know the total number of adidas we sold on the entire column B, so I select the option box says adidas then click on count button, it will then give me the result of 6 next to Label1, below is my code but seems not work.



Please note that the data that i received is system generated and data are contained in one cell by new line, so that is complicated for me.

Please also see attachment of how my userform look like.



Private Sub Count_Click()



Dim result As Double

'Assign the variable

result = Application.WorksheetFunction.CountIf(Range("B2:B50"), "adidas")

'Show the result

Label1.Caption = "result"



End Sub



Thanks and appreciate that!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Counting quantity - data contained in one cell by new line - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kev2131]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Counting quantity - data contained in one cell by new line - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thank you and sorry for that!

 

[kev2131]

Due to cross posting, could you please remove this thread, thank you!

 

[Fluff]

There is no need to have the thread removed.