Picklists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a picklist of values to select from and running into
issues. I defined the values I want to choose from on a separate worksheet
in the some workbook and assigned it a name. When I go to the worksheet
where I want to access the picklist, I did the following:

Data > Validation

In the allow section, I selected "List" and in the source field, entered the
name of the range I had defined. Excel is only displaying the name of the
range that I entered, not the actual values I need. Any thoughts???

Thanks,

Darren
 
In the Source Field, did you precede the name of your range with an equal sign?

=Your_Range

HTH,
Elkar
 
Back
Top