creating drop down menus

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

Guest

Still relatively new at REALLY using excel. I would like to ideally create a drop down menu containing several choices, and then based on that highlighted selaection, more selections are displayed in another drop down menu. For example, the drop down menu would first list several systems (systemA, systemB, and systemC). If systemA is highlighted by the user, then another menu pops up for them to select more choices from. Same with systemB and systemC. Kinda like a "cascading" menu effect. How do I do this? Please help!!!
 
I have a workbook that does this for any number of linked lists.

Mail me 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)

shpongleguy said:
Still relatively new at REALLY using excel. I would like to ideally
Click to expand...
create a drop down menu containing several choices, and then based on that
highlighted selaection, more selections are displayed in another drop down
menu. For example, the drop down menu would first list several systems
(systemA, systemB, and systemC). If systemA is highlighted by the user,
then another menu pops up for them to select more choices from. Same with
systemB and systemC. Kinda like a "cascading" menu effect. How do I do
this? Please help!!!
 
I need your email address, where you post from obliterates it.

--

HTH

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