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

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
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying a range based on a cell's contents 3
External cell reference between two excel worksheets both in One Drive 0
Data Validation and drop-down list using IF, AND and what else? 8
Cause and Effect chart convertion 0
Extracting Values from text embedded in cell 10
look to a cell for a reference to a sheet 2
Can't reference a named cell in VBA 4
Arrays and scattered cell values or another way? 16

Top