Msg Box Userform

[Abhishek1988]

Hi Everyone,

Hope all are fine.

I have very basic knowledge about the VBA and looking out for some help.

I have a combo box in excel userform (cmboxabc), which is depend on multiple options buttons and one textbox value.

I want if all options buttons are unchecked and textbox value is blank and user try to see click on combo box to see dropdown value then user would be one error msg that "please select option button and provide text value".

Please help me with the same and also provide me the location where i need to paste required coding.

let me know if you have any further questions.

 

[Abhishek1988]

Re: Msg Box Userform Help

Not sure but by this coding i am able control combo box by textvalue. i can easily able to access combo box by clicking on drop down alone. i need both the condition should met text and optionbox both

What you could do is start the userform with the combobox Enabled=False. The user can't click on the box until the Enabled property is True.

Use the checkbox and textbox Change events to decide when conditions are right to change the Enabled to True

cmboxabc.Enabled = (TextBox1.Text <> vbNullString) And (OptionButton1.Value Or OptionButton2.Value Or OptionButton3.Value)