Problem with Frames in userform

J

JUAN

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
 
C

Charles

JUAN,

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

HTH

Charle
 
J

juan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top