I have created a worksheet with Opt 1

[mcm103]

I have created a worksheet with Option buttons. A user can click on the buttons to indicate the status of the item he/she is working on.

I want to create a macro that will reset the worksheet by changing the options buttons to the inital setting. I have been unable to target an indiviual option button value property.

Any suggestions?

 

[SkipVought]

Hi,
How did you created your option buttons???

1. Forms or
2. Control Toolbox? Skip,
metzgsk@voughtaircraft.com

 

[SkipVought]

Well you could do this...

Sub ResetOptionButtons()
    For Each OptionButton In ActiveSheet.OptionButtons
        OptionButton.Value = False
    Next
End Sub

This sets them all OFF. You could set them to a different value.

Hope this helps Skip,
metzgsk@voughtaircraft.com