Countif question

[Fyr]

I'm using this line to count how many times textbox1.value is found:

COUNTNUM = Application.WorksheetFunction.CountIf(.Columns("B:B"), Textbox1.value)

If there a way to have a msgbox show which rows the item was found in?

thanks!

 

[texasalynn]

you would need to do a loop to gather the cells it was found in