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

  • Thread starter Thread starter Douglas
  • Start date Start date
D

Douglas

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
 
Back
Top