Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box should trigger another combo box
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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box should trigger another combo box
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. -- Thanks, Shane Devenshire "karthik" wrote: 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!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box should trigger another combo box
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... "ShaneDevenshire" wrote: 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. -- Thanks, Shane Devenshire |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet | Excel Programming | |||
Combo Box Trigger for Macro using Worksheet_SelectionChange | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |