message box pop up within userform, clicking ok closes userform

[teacher_rob]

This place has been such a great resource for me in the past ! Thanks to all who help all of us beginners !!!

I have a userform with several frames, each frame containing 10 option buttons. Users must select one option button from each frame. As i have it coded now, if the user chooses save, and there is a frame without an option button selected, an error message pops up... "please input score for frame X" So far so good, however, if the user clicks the "OK" button on the message box, the entire userform closes... What i need to happen is that the message box goes away and the user is back looking at the userform.

I can't figure this out !

[romperstomper]

What code are you using currently?

[rvasquez]

Hello there,

Could you post your code to the on save button click event?

Thanks!

[teacher_rob]

[romperstomper]

You need to add

Please Login or Register  to view this content.

after each Msgbox line.

[BigBas]

I'm just going to chime in and ask if you'd like to post a copy of the workbook? Oftentimes (although not always) when code is extra repetitive, there is a better or more efficient method of coding. I'm sure we'd be glad to take a look if you posted.

[teacher_rob]

romper stomper - thanks so much ! i figured it was something simple !
big bas, in the future, i most likely will... as i newbie vba guy, i'm sure most of my coding could be reduced by better planning

thanks guys !
-rob

[Cutter]

@ teacher_rob

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.