Option button to toggle msgbox

**hockeyadc** · 02-27-2013, 05:18 PM

I have 2 groups of option buttons. When the user clicks on a specific combination, I want an error message to pop up. How can I go about coding this?

**scott.s.fower** · 02-27-2013, 06:13 PM

you might have to have the buttons "trigger" a checkbox or input a number into a cell so if you have say 5 buttons and the error is triggered by pressing button 1, 4, 3 then button press 1 will put a 1 in say z1, press button 4 will put a 4 in cell z2 and press button 3 will put a 3 in cell z3. then write a formula to look at cells z1, z2, and z3 like

of course you will have to change the If sumerr = 143 part to include all error combos like If sumerr = 143 or sumerr = 413Then MsgBox "Error"

errx is for each button, each button should have a unique number associated with it

Please Login or Register  to view this content.

then write code so that if you click the button it will put the number in the z column example codes for CommandButton1

Please Login or Register  to view this content.

**scott.s.fower** · 02-27-2013, 06:24 PM

is there going to be a submit button or do you just want it to do it automatically? also what do the buttons do? it might help me to give you a better idea

**Hawkeye16** · 02-27-2013, 06:31 PM

Personally I would just assign macros to the ones that cannot be combined telling them to check the state of the others and return an error message box (and reset the buttons) if the wrong combination is present.

**hockeyadc** · 02-27-2013, 06:37 PM

I wanted it to do it automatically, so there really wasn't a macro to initiate. I actually figured it out though. I wrote a macro and assigned the option buttons to it, so as they click on them it "automatically" makes sure its a valid combination.

Thanks for the help guys!

**hockeyadc** · 02-27-2013, 06:38 PM

Originally Posted by Hawkeye16

Personally I would just assign macros to the ones that cannot be combined telling them to check the state of the others and return an error message box (and reset the buttons) if the wrong combination is present.

This is what I did thanks!