error in data transfer of userform w/ 3 options buttons

[HeyInKy]

On my userform, I have several questions with Yes/No option buttons. When my Save/Close command button is executed, I have the following code to transfer the data:

Please Login or Register  to view this content.

This worked fine. But now I have had to change the last question (#12) to include not only Yes/No, but a third option button, "NA".

So I modified highlighted code above to the following (below) and changed nothing else, and I get a "Compile Error: End With without With" message. Any suggestions?

Please Login or Register  to view this content.

[LJMetzger]

Hi BlueGrass,

Try this (code excerpt) - changes in red:

Please Login or Register  to view this content.

Single step through the code and make sure the 'Blue' code executes when you want it to.

Lewis

[Norie]

That error doesn't really have anything to do with With/End With, it's because the If statements in your code aren't quite structured correctly.

Actually I'm not sure multiple Ifs is the best approach.

Instead you could use a Select...Case structure, something like this.

Please Login or Register  to view this content.

[HeyInKy]

@LJMetzger - worked fine except I didn't need the last 'End If' statement.

and @Norie, as usual, your advice is spot on. Thanks!

-HeyInKy ...from the Bluegrass