I would like to turn a cell ie (B2) into a listbox , the listbox will
contains a range of cells ie (A2:A20) from another sheet in the same
file.

I would then like to be able to refer to B2 in VB or if statements

i.e.

=if(B2 = "Wheat", 0,1)

I played around with "Create List" by right clicking a cell, but i
didnt seem to do what i wanted.

TIA

Doug