Yo,

puting

Me.Hide

in the ok buttons click event will hide the userform, but, and i'm
not sure i full understand what you are try to do, that not so good
for you, becasue you want to do diffrent things based on the choice
made on the userform,

Try this way:

some code to open the user form

YourFormName.Show

Now the form is open. It has all the option you might need on it. The
user chech on box or option and click ok.

now you must tell the programe what to do, based on what the user has
clicked so..

OKbutton_click

if optionbox1.value=true then
NameOfYourSubToGoTOIfThisCondtionIsPicked
elseif
AnotherSub
Else if

etc etc

'''Now close you form.

me.close

end sub


next time you open this form the last check box will still be checked,
but the sub will not run unless the user pressess OK


Good Luck

ROss