VBA code not recognising selected option button

Hi,

I am creating a simple userform to change the view of a sheet depending on which option has been selected. There are 3 option buttons on the form (optAll, optDeco, optGlaze) and I have set the value to true for optAll.

When the user clicks the 'OK' image (I prefer things to look nice instead of using standard buttons) the below code doesn't recognise which option is selected and skips to the msgbox line:

Please Login or Register  to view this content.

I already have created another form with options using the same approach without an errors. Can anyone shed any light as to where I may be going wrong?

Thanks
Harribone

Difficult to comment without seeing the workbook, but why not just attach whatever code you want to run to the click event of the option buttons. It's not clear why you need to select an option and then click another object like an image.

Hi Rich,

Sorry ignore me!

I've just realised that I haven't put 'Exit Sub' within the If statements hence why I though it was jumping to the MsgBox line.
I think I need a coffee to wake myself up!


On a side note the image that is clicked is in place of an OK button. If the code ran on selection of an option then I am assuming the user has selected the right option first time which may not always be the case (my users computer skills are to be considered non existent so am making room for human error doing this).

Appreciate the quick response though,

Thanks
Harribone

Originally Posted by Harribone

Hi Rich,

On a side note the image that is clicked is in place of an OK button. If the code ran on selection of an option then I am assuming the user has selected the right option first time which may not always be the case (my users computer skills are to be considered non existent so am making room for human error doing this).

Thanks
Harribone

I understand your concern but if the user can't be relied on to select the right button first time and he knows that his next step is to click an OK button, that sort of user isn't going to hang around thinking have I selected the right option, they'd just click the OK button without thinking. It's human nature.

It does raise the obvious question though and that's what IS the right button as far as that user is concerned and how would you know whether he'd selected the 'right' button or not.

Suppose the wrong selection is made on the first occasion, is there any reason why another option button can't be selected to correct the first process?