Which button was pressed?
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
|