I'm trying to create dependent drop-downs with complex sentences so for example if in the first box someone choses Objective 3

Objective 3 - Concrete improvements in sectors


Then I want them to only be able to choose from the five sub-objectives that belong to Objective 3.

3.1 Improved health services
3.2 Improved WASH service and infrastructure
3.3 Improved access to sanitation services
3.4 Improved education services and infrastructure
3.5 Improved livelihood opportunities

Then I want them to have program component selections based on the sub-objective they choose. I can do it if I just limit my entries to one-word, but I would like to have sentences for more clarity.

Any suggestions?

Sincerely,

Tiana Tozer




mj_bowen wrote:

VBA code for drop down menu problem.
03-Feb-10

Hi,

Basically if any of the names is selected in any of the drop down cells,
then the score that is next to that cell eg, 1a,2b, 3c, 4c is shown next to
the appropriate name in the APP sheets tab!

I have attached a copy of the worbook;
http://www.box.net/shared/hxr0isxpfi

I have tried all sorts but cannot seem make it work!

Matt

This thread is also posted on
http://www.mrexcel.com/forum/showthr...=1#post2202650

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Image2HTML Image to HTML Conversion Reloaded
http://www.eggheadcafe.com/tutorials...e-to-html.aspx