userform to select option button without running the code that's in it

Hi kosherboy

One approach would be, once the Option Button is clicked, disable it.

Please Login or Register  to view this content.

Let me elaborate:
When i plugged in your idea the code was still running the code in the option button.
How can i have the userform mark the optionbutton value as true without running its code?

You need to use a control variable that the optionbutton code checks before running its own code.

How/why is the option button being selected when the userform opens?

Is it linked to a cell?

At the top of the form module :

Please Login or Register  to view this content.

Then the first line of the optionbutton code needs to be:

Please Login or Register  to view this content.

And wherever you need to change the value without running the code, you use:

Please Login or Register  to view this content.

for example.

What happens if you remove the posted code from the form's Initialize event?

Originally Posted by kosherboy

Hi romperstomper,
I did as you suggested but it seems the code is still executing.

That isn't possible if you did what I said. Please post the entire code you used.

Userform initialize:

Please Login or Register  to view this content.

executes when option button is selected:

Please Login or Register  to view this content.

Is called from the code which executes from the option button

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This line should be at the top of the module outside any procedures, and nowhere else.

I mean at the top of the module, before any private sub routines.