Activate and deactivate the text box with option button in Excel

[mmn1000]

Hi;
How can I enable and disable multiple text boxes using the combo box option button?

 

[Micron]

That would mean what, I choose list item 1 in the combo and textboxes 2 and 3 are disabled? Choose combo list item 2 and other textboxes are disabled? And those that were disabled no longer should be when another option is chosen? Or they remain disabled?

To answer simply and based on my interpretation of your question, you would use the AfterUpdate event of the combo and act according to what you want. However, I don't know what a combobox "option button" is. There are also controls called option buttons but I suspect those are not involved here.

 

[mmn1000]

Let me pose my question like this.

I have 6 ComboBox and 2 OptionButton in my UserForm
How can I disable some ComboBoxs by selecting OptionButton 1 so that nothing can be written in it?
When I select OptionButton2, all ComboBoxs are active and editable for me

 

[Micron]

Here's one way but this is off the top of my head, thus is untested:

open form in design view, put a value in the Tag property for each of those combos. Could be anything; let's use "LockMe" without the quotes. Then
create option button AfterUpdate events for both buttons. Put this line for enable button:
EnableCombos True

and for disable button put
EnableCombos False

Then create a sub (also in the userform)

Private Sub EnableCombos(bolState As Boolean)
Dim ctl As control

For Each ctl In Me.Controls
     If TypeName(ctl) = "ComboBox" And ctl.Tag = "LockMe" Then
         ctl.Enabled = bolState
    End If
Next

End Sub