Lists

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is it possible to select an option in one list and have a
corresponding cell display another list. i.e.

In Cell A1 you have dropdown list. The list
is "Print", "Run" and "Stop".

If I select "Print" in A1 then I want a particular
dropdown list to appear in B1.

If I select "Run" in A1 then I want a different dropdown
list to appear in B1. And so forth.

Any help.
 
Bob,

I have a sample workbook that does this. Mail me direct if you want a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top