excel vba - IF option button selected Then...

  • Thread starter Thread starter chief
  • Start date Start date
C

chief

Basically, what will happen is they click the save/print commanbutton o
the sheet, this brings up a userform asking them yes or no, what wil
now happen is when they click on either yes or no commandbuttons,
want a code to recognize if one of the four option buttons on the shee
has been selected, if one has been selected it will run its course. I
not, it will close the save/print userform and select cell "K5" fo
example whereby they can choose an option button and move on.

What would be the selection recognition code that i could store in m
save/print userform?

thank
 
something like this:
if option button1 = true or option button2 = true or
option button3 = true or option button4 = true then
run it's cource
else
unload me
range("K5").select
 

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

Back
Top