Can i turn a cell into a listbox and refer to the list value using the cell's reference

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

Hi Douglas

maybe data / validation - list, with A2:A20 as the source
which gives a drop down arrow in the cell
would give you what you need?

Cheers
JulieD

"Douglas" <[email protected]> wrote in message
news:[email protected]...
>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