Change multiple control values based on opt selection

[AndyEd]

I have code to change multiple control values to "NA" when the value of an opt control is False.

Rather than coding for them individually, e.g.

if opt2.value= true then
.txt1.value = "NA"
.txt2.value = "NA"
:
:

Is there a way that I can code for all controls together, such as placing them in an array for something?

Thank you for any assistance.

 

[Jeffrey Mahoney]

This is just an example, but it shows how you can change the value of many checkboxes to the same value as long as the controls are named similarly.

Public Nxt As Long

Private Sub CommandButton1_Click()
  
  Dim X As Long
  Dim Astr As String
  
  Nxt = Nxt + 1
  For X = 1 To 4
    Astr = "TextBox" & X
    Test_Frm.Controls(Astr).Value = Nxt
  Next X
  
End Sub