List Box
 

I've never worked with List Boxes and I think that I may need to learn now.

I'd like to create a list box with values to search for in column B:

If Apples is selected then search in column B for:
Apples
move one column over: ActiveCell.Offset(0, 1).Range("A1").Select
Perform a "get pivot data" from another workbook on that cell - there is an
If statement in here in case the value isn't found
Then search for the next instance of Apples and do the same thing

Any suggestions would be VERY MUCH appreciated!!