OptionButton

Good morning diono

...and welcome to the forum!!

From what you say, it sounds like you are using option buttons off the forms toolbar. If you want more control you would be well advised to use the option buttons from the Control Toolbox toolbar which offer you a finer degree of control over the issue, but in return are more difficult to work with. Once set up double clicking the control will open the associated module window which allows you to enter event procedure code defining what is to happen when a user interacts with the buttons.

HTH

DominicB

Hi

You can assign a macro when it is clicked, so you could set up a macro attached to one option button that does one thing, and a different macro to do something else when the other button is selected. However, you can only capture the value of the option button to a worksheet cell.

Using objects from the Control Toolbox form gives you a much wider scope for control, enabling you to run macros when they are selected, and load the value of the option buttons as a variable. There are also dozens of properties for you to play with controlling how the control both looks and reacts with users.

HTH

DominicB