List items determined by content of previous cell

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

Guest

Office XP

Is it possible to make the items on a drop-down list dependant on the
content of the previous cell, which has also been selected from a drop-down
list?

Hope someone can help.

Thanks in anticipation.
 
Hi,
I am not sure what you mean by drop-down lists without more detail, but
the links below should get you started in the right direction.

The first link is if you are using listboxes. The click event in the
first list box can help you dynamicly fill the second listbox. The
second link is if you are using data validation.

Dynamic list box: (See Tom Ogilvy's Response)
http://groups.google.com/group/micr...faa?q=listbox+dynamic&rnum=5#ca331cd5b1d19faa

Data validation: (drop-down list?)
http://www.contextures.com/xlDataVal02.html


HTH-Lonnie M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Colour-coding a cell from a drop down list 1
Pick from drop-down list gives empty or erroneous result 6
Data Validation List (conditional) 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Excel Excel: How do I put a formula in a drop down list 11
Clear a "moving" range offset from Target 31
Dropdown List Add New Feature Needed 29
Define the Range of a drop-down list 5

Back
Top