Picklists

[Darren]

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

 

[Elkar]

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

=Your_Range

HTH,
Elkar

 

[Darren]

Thanks, Elkar.

That did it!

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

=Your_Range

HTH,
Elkar