Hello All,
I have a userform and I have four frames which each frame
has four option Example
Frame 1 Frame 2
optionbutton 1 optionbutton 1
optionbutton 2 optionbutton 2
optionbutton 3 optionbutton 3
optionbutton 4 optionbutton 4 etc.

If i check option1 in frame 1 it works fine so when I come
back to form, the option1 is checked, so when I check
FRAME2 option1, both are checked so won't run right macro.
Is there a way that after I run an option to leave blank
or woudl I have to delete all frames and just do one big
frame? This means I would need to redo form.
Looking for an easy fix.
Hope I'm clear. Please advise feedback would appreciate
all the help.
Thanks,
Juan

JUAN,

Assuming you have a code for each optionbutton. at the end of each cod
you can set the OPtionbutton to false.

HTH

Charle

--
Charle
-----------------------------------------------------------------------
Charles's Profile: http://www.excelforum.com/member.php...nfo&userid=601
View this thread: http://www.excelforum.com/showthread.php?threadid=27264

Hello Charles,
thanks for the info. This should do it for now. It works.
If I click on an option but i dont' want to run it, i can
create a Clear Button so that it makes the buttons blank.

ONCE again, I really appreciate all your help.

Thank you,

Juan
-----Original Message-----

JUAN,

Assuming you have a code for each optionbutton. at the
end of each code
you can set the OPtionbutton to false.

HTH

Charles


--
Charles
----------------------------------------------------------
--------------
Charles's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=6014
View this thread:
http://www.excelforum.com/showthread...hreadid=272648

.