Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox programming
Hi,
I want to do the following: Table 1 (Configuration): project1 action1 action2 action3 project2 action6 action7 action8 Table 2: I want to have two comboboxes. The first should be used to choose one of the projects. If a project is chosen, the actions of this project should be in a second combobox. Is this possible?? Thanks, Christian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox programming
Hi Christian
Make the ListFillRange for combobox 1 reflect the cells containing the project names then use the following code to select the ListFillRange for combobox2 depending on the selection in box1 Private Sub ComboBox1_Change() If ComboBox1.Text = "project 1" Then ComboBox2.ListFillRange = "j1:j3" ComboBox2.Text = "" Else If ComboBox1.Text = "project 2" Then ComboBox2.ListFillRange = "k1:k3" ComboBox2.Text = "" Else: ComboBox2.Text = "Select project first" End If End If End Sub Hope this helps Ian "Christian Reusch" wrote in message om... Hi, I want to do the following: Table 1 (Configuration): project1 action1 action2 action3 project2 action6 action7 action8 Table 2: I want to have two comboboxes. The first should be used to choose one of the projects. If a project is chosen, the actions of this project should be in a second combobox. Is this possible?? Thanks, Christian |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox programming
Christian,
I have a workbook example of how to achieve this sort of dependent combobox. 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) "Christian Reusch" wrote in message om... Hi, I want to do the following: Table 1 (Configuration): project1 action1 action2 action3 project2 action6 action7 action8 Table 2: I want to have two comboboxes. The first should be used to choose one of the projects. If a project is chosen, the actions of this project should be in a second combobox. Is this possible?? Thanks, Christian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
vba programming | Excel Discussion (Misc queries) | |||
Programming help | Excel Discussion (Misc queries) | |||
Programming IDE | Excel Programming | |||
Help With Simple Combobox Programming | Excel Programming |