Checkbox array with string

Question

I need help on how to use checkbox array , if checkbox is checked the value will be:

check1(0) = OK ,check1(1) = X,check1(2) = [X],check1(3) = NP
a=iif(check1(0).Value = vbchecked,"OK")

Getting error:

"Error sub or function not defined"

Are you sure you want to use iif and not if. See help. If check1(0).Value = vbchecked then A = "OK". — user12431753
– user12431753, Commented Mar 2, 2020 at 2:36
I have 4 checkboxes if I check(0) then the value will be ok and if i check(1) the value will X. — Kent Maquirang
– Kent Maquirang, Commented Mar 2, 2020 at 3:31

Brian M Stafford · Accepted Answer · 2020-03-02 12:40:50Z

1

I'm not sure how the line of code you presented would generate the error sub or function not defined. Rather, you should have received the errorArgument not optional. The syntax for this line should have been like this:

a = IIf(Check1(0).Value = vbChecked, "OK", "")

If I understand your requirements, you COULD use IIf like this:

a = IIf(Check1(0).Value = vbChecked, "OK", IIf(Check1(1).Value = vbChecked, "X", IIf(Check1(2).Value = vbChecked, "[X]", IIf(Check1(3).Value = vbChecked, "NP", ""))))

However, I would not recommend this approach. Instead, I would structure the code like this:

If Check1(0).Value = vbChecked Then
   a = "OK"
ElseIf Check1(1).Value = vbChecked Then
   a = "X"
ElseIf Check1(2).Value = vbChecked Then
   a = "[X]"
ElseIf Check1(3).Value = vbChecked Then
   a = "NP"
Else
   a = ""
End If

Yes, there is a little more code but the code is easier to read and easier to maintain.

edited Mar 2, 2020 at 12:40

answered Mar 2, 2020 at 12:26

Brian M Stafford

8,9432 gold badges19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Checkbox array with string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related