Combo Box Userform To Open 2nd Combo Box

**WPJensen** · 03-08-2011, 08:37 PM

I have a Combo box Userform with selection A B C D dropdown. Want to be able to select any (in this example) B that opens a 2nd Combo Box Userform with all B's display.

I have the 2 boxes working as desired but can't get the first box to select the appropriate (in this case B) in the 2nd Combo Box Userform.

Private Sub ComboBox1_Change()
Select Case ComboBox1.Value

Case "A"
ComboBox2.DropDown

Case "B"

Case "C"

Case "D"

End Select

End Sub

Private Sub Label1_Click()

End Sub

Private Sub UserForm_Initialize()

ComboBox2.AddItem "A"
ComboBox2.AddItem "B"
ComboBox2.AddItem "C"
ComboBox2.AddItem "D"

End Sub

Would also like some help on a macro for OK & Cancel button

Not sure whether I have explained this good enough, been working on this for a couple of weeks learning VB as I go

Wayne

**6StringJazzer** · 03-09-2011, 09:24 AM

Welcome to the forum!

Please read the forum rules. Rule #3 requires enclosing code in code tags (see my signature for instructions). This preserves the formatting of the code and makes it readable. You will probably want to be familiar with the other rules as well (there aren't that many!).

Originally Posted by WPJensen

...opens a 2nd Combo Box Userform with all B's display.

I have the 2 boxes working as desired but can't get the first box to select the appropriate (in this case B) in the 2nd Combo Box Userform.

Sorry but I'm not following this. What do you want to be listed in the second combobox if the user selects B from the first? A concrete example might help.

Your code has the line

Please Login or Register  to view this content.

This line of code simply causes the combobox to show the list. I don't know if that's what you intended. In the same place where this line of code is, you have to populate your second combobox with whatever values are appropriate for a selection of B in the first combobox. You must first use

Please Login or Register  to view this content.

to wipe it clean and that add whatever items you want. You can do this by associating it with a worksheet range, looping through some list, or simply adding them one by one like you have done with your first combobox.

**6StringJazzer** · 03-09-2011, 09:27 AM

BTW your cancel button will most likely be something like

Please Login or Register  to view this content.

which simply closes the form with no action.

For your OK button, implementation is completely dependent on what you want to happen with the values the user has chosen, which you don't describe.

**WPJensen** · 03-09-2011, 04:47 PM

Originally Posted by 6StringJazzer

BTW your cancel button will most likely be something like

Please Login or Register  to view this content.

which simply closes the form with no action.

For your OK button, implementation is completely dependent on what you want to happen with the values the user has chosen, which you don't describe.

Thanks I have the cancel button working.

As for the OK button say select B Click ok then have it open a second combo box that has a drop down list of all B.

Then Select a B1 from that list click ok to activate exe file, I have this Step working already.
Wayne

**6StringJazzer** · 03-09-2011, 06:34 PM

Originally Posted by WPJensen

As for the OK button say select B Click ok then have it open a second combo box that has a drop down list of all B.

I would suggest populating and showing the second combo on change to the first one, rather than waiting for the user to click OK. In fact that's the direction that your code is already going. When you click OK it should look at the value in the second combo, and then do whatever it is you want to do with it.

**WPJensen** · 03-09-2011, 11:21 PM

Originally Posted by 6StringJazzer

I would suggest populating and showing the second combo on change to the first one, rather than waiting for the user to click OK. In fact that's the direction that your code is already going. When you click OK it should look at the value in the second combo, and then do whatever it is you want to do with it.

I understand what your saying and it makes good sense only thing I do not know VB well enough to be able to make the macro to do this

Can you help here please Thanks very much Wayne

**royUK** · 03-10-2011, 04:01 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**WPJensen** · 03-10-2011, 04:34 AM

Originally Posted by royUK

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Sorry I have no idea what you are talking about New here and to VB

Wayne

**royUK** · 03-10-2011, 06:33 AM

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Various tags are explained in the link above