Combo box should trigger another combo box

[karthik]

Hi ,

Can tell me the way how could i make a combo box change according to the
selection of another combox values.

for example : if a combo box contains values such as "days of a week(ie
monday,tuesday,wednesday..... )" if one selects monday the other combo box
should display the values specified for monday(like places i need to go on
monday).

please help me out!!!

 

[ShaneDevenshire]

Hi,

Suppose the two combo boxes are in the spreadsheet? As a test, to
illustrate the technique: I will use the Data, Validation command to
demonstrate this idea. If you are using another combo box then let us know
whether it is a Form or Control Box control:

Range A1:A2
US
Canada

In range B1:B2
New York
San Francisco

Select B1:B2 and type US into the Name Box (the far left side of the Formula
Bar, where cell addresses appear) and press Enter. The name must be spelled
the same as you enter in A1.

In range C1:C2
Quebec
Toronto

Select C1:C2 and type Canada into the Name Box (the far left side of the
Formula Bar, where cell addresses appear) and press Enter. You must press
Enter!

Move to a cell where you will have your first a drop down list, say E1.
Choose Data, Validation, from the Allows box choose List, in the source box
enter =A1:B1 and press OK. Now you have a drop down list with two choices in
cell E1, the arrow shows when you click in the cell.

Move to the cell where you want your list to depend on the result the entry
in E1. Say H1, and choose Data, Validation, and from the Allows box choose
List, in the source box enter =INDIRECT(E1). When you click Ok you may get
an error message, ignore it.

Now test everything. Open the list in E1 and pick one of the two entries.
Move to H1 and open the drop down....

If this helps, please click the Yes button.

 

[karthik]

Hi,

Thank you for the post, it was helpful.

I have another request, suppose if the values have spaces (like instead of
"US" if its "C & C++ Programming"/ "Java Programming" and in the other combo
box if i plan to display the "Corresponding Authors" )
when i tried to name the selected field as "C & C++ Programming", it showed
an error like Special Characters not allowed.

what can i do if this is the case..???

Please Reply...