Help on vba code to open user form msg box(check box) from combo box

[aman2059]

Hi All,

I am working on vba code and not able to get out of one problem. Below is my problem.

I have created two user form 1) Combo box 2) Check box(I have created 3 check box based on combo box values)

Now, I need that I run macro and it gives me first combo box and when I select value from combo box, it gives me a check box according to the value selected in combo box

NOTE: Combo box has three different values

I tried to do above but couldn't find the solution. Please help.

Please let me know if I need to give more information.

Thank you in advance for help.

 

[aman2059]

Could anyone please help me on this?

 

[aman2059]

I am giving one more try, if someone can help. Below is the code to open combo box.

Note: process box is a name of user form combo box.

Sub processbox1()

 processbox.Show

End Sub

below is the code from Userform box(combo box)

Private Sub btnCancel_Click()

End Sub

Private Sub d_Change()

End Sub

Private Sub ComboBox1_Change()

 
End Sub

Private Sub CommandButton1_Click()

[B]If ComboBox1_Change = IIL Then

Call regionsbox

elseif ComboBox1_Change = AIL Then

Call module6

End If[/B]

End Sub

Private Sub Label1_Click()

End Sub

Private Sub UserForm_Click()

End Sub

In the above code I tried to add "call" (in command button) to call another macro which has another user form box(combo box) in the code. Below is the code to open another box

Sub regionsbox()
 
 regionsselection.Show
 
End Sub

Please let me know if someone can help.

 

[aman2059]

sorry I am new to user form, so above might be totally wrong. However I posted it.