Picklists
 

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

Picklists
 

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

=Your_Range

HTH,
Elkar


"Darren" wrote:

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

Picklists
 

Thanks, Elkar.

That did it!

"Elkar" wrote:

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

=Your_Range

HTH,
Elkar


"Darren" wrote:

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