Combo Box Value depend on checkbox and TextBox - USERFORM

[Rahulwork]

Hello Everyone,

I have a userform in which i made two combo box, below are the name's

ComFruits_Change()

ComVeg_Change()

Both combo box having informations like below:

Private Sub UserForm_Initialize()

ComFruits.AddItem "Apple 1"
ComFruits.AddItem "Apple 2 "
ComFruits.AddItem "Orange 1"
ComFruits.AddItem "Orange 2"
ComVeg.AddItem "Tomato 1"
ComVeg.AddItem "Tomato 2"
ComVeg.AddItem "Potato 1"
ComVeg.AddItem "Potato 2""



Now i have two check boxes, below are the name's

Private Sub Fruit_Click()


End Sub

Private Sub Vegetable_Click()


End Sub


and last i have one text box, below is the name:

Private Sub txtABC_Change()


End Sub



Now i want if Fruit checkbox is checked then ComFruits_Change() , should be active and other one should be inactive, same with if Vegetable checkbox is checked then ComFruits_Change() should be inactive and other one should be active.

then if txtABC value is apple then under ComFruits_Change(), apple 1 and apple 2 value should reflect, same if value is orange then ComFruits_Change(), orange 1 and orange 2 should reflect.


Please help me with the same. i tried but couldn't happn

 

[Rahulwork]

Re: USERFORM Combo box

Hi, thanks for your response.

I think by mistake you mentioned combo box name on place of checkbox name and vise versa,

by below, i am still able to open both the combo box

Private Sub ComFruits_Click()
Call Fruit_Change
End Sub

Private Sub ComVeg_Click()
Call Fruit_Change
End Sub

 

[mikerickson]

Re: USERFORM Combo box

I don't know what you mean by "open both the combo box"
That code will allow you to select from either box at any time. But which combobox controls what is shown in the text box is determined by which option button is checked.