NEXT/PREVIOUS OPTIONBUTTON

[Ronbo]

Is there a way to create a routine that would beable to run the next or
previous OptionButton.

I have a UserForm that has five OptionButtons(1-5). When the user clicks on
one the given code is run. What I want to beable to do is go to the next or
previous OptionButton with a button rather than going back through the
process of opening the UserForm and choosing the next or preiouvs.

As always, any help is appreciated.

 

[rmullen]

you'll want to look into doing a tab option group and customzing the
tabs to do your next-previous operations.

 

[Jim Thomlinson]

Assuming that all you have done is hidden the form and not unloaded it you
can retrieve the value of the option buttons. Obviously you are going to have
2 buttons for next and previous on your spreadsheet or wherever. You can read
the values of the option buttons something like (Next Button Code)

With UserForm1
If .OptionButton5.Value = True Then .OptionButton1.Value = True
If .OptionButton4.Value = True Then .OptionButton5.Value = True
If .OptionButton3.Value = True Then .OptionButton4.Value = True
If .OptionButton2.Value = True Then .OptionButton3.Value = True
If .OptionButton1.Value = True Then .OptionButton2.Value = True
End With

 

[Ronbo]

Thanks Jim, that is exactly what I am looking for. However, when I get to
OptionButtton5 and click next it jumps to Optionbutton2. It runs
OptionButton1 and then OptionButton2 where it stays. Any ideas as to why