what could a pull-down list be?

T

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?
 
N

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).
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
T

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).
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
N

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)
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top