Userforms with multiple case

[ncoatney]

I have a userform with several text boxes. Two are tied to select case statements. What I'm after is if the defect is "sheet metal (bent)" and the reason is "bent to long" I need it to put 01001 into a cell. That part is simple enough. The problem I have is that with each defect there are several reasons, and each has it's own unique number. Other then writing multiple if and else if statements, is there an easier way to do this?

 

[ncoatney]

Apparently I don't know how to insert anything. I can send the excel file if need be.

 

[Joe4]

You could conceivably set-up a lookup table of all possible combinations and use an INDEX/MATCH formula (no VBA required).

In VBA, I would probably nest the Case statements, i.e.

Select Case textBox1.Value
    Case a
        Select Case textBox2.Value
            Case aa
        ....
        End Select
    Case b
        Select Case textBox2.Value
            Case aa
        ....
        End Select
    ....
End Select

Note that unless there is some sort of pattern, duplication, or overriding values, you will probably need to spell out each option in VBA.


EDIT:
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.