Problem with Frames in userform
 

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

Problem with Frames in userform
 

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

Problem with Frames in userform
 

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

.