what could a pull-down list be?

[Tammy]

Argh...
I've been asked to help troubleshoot a spreadsheet which
has a pulldown list, the options from which seem to be
populated from a range of cells elsewhere on the sheet

My colleague has two versions of this workbook; one has a
valid and compelte list of options, the other has
each "listbox" appearing as blank, or with just one option.

I need help figuring out what the feature is that's even
being used here... The workbook was created by someone
else and I need to troubleshoot why it's behaving the way
that it is.

This is not a pivot chart. How can I tell whether it's a
list that's been added from the Forms toolbar? What else
might it be?

 

[Andy Brown]

"Tammy",

possibly Data Validation -- see http://www.contextures.com/xlDataVal01.html

HTH,
Andy

 

[Norman Harker]

Hi Tammy!

Looks like you need to look at Data Validation.

Select one of the drop down cells then
Data > Validation

The first tab should give you details on the list used.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 21st July: Belgium (National Day),
Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam
(Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru
(Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Tammy]

oh, thank you thank you thank you

-----Original Message-----
Hi Tammy!

Looks like you need to look at Data Validation.

Select one of the drop down cells then
Data > Validation

The first tab should give you details on the list used.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 21st July: Belgium (National Day),
Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam
(Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru
(Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.

 

[Norman Harker]

Hi Tammy!

Thanks for thanks is always appreciated and shows lurkers and google
searchers that a solution works.

Stick around and participate; it's a great resource.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 22nd July: Gambia (Liberation Day),
Poland (National Liberation Day), Slovenia (People's Uprising Day),
Swaziland (Birthday King Sobhuza II)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.