User Form with option buttons

[Aland2929]

On my user form, I have a few option buttons within different frames. I use [If Then] to allocate the selection to a cell range but the cell is only updated when I click the OK button on the user form:

Please Login or Register  to view this content.

If OptionBMW Then Range("Category") = "BMW"
If OptionMercedes Then Range("Category") = "Mercedes"

What code can I use for option buttons so the cell address changes as I change my selection on the user form?

Thank you.

[Norie]

You could put the code in the Click events of the buttons.

Or have a separate sub that runs the existing code and call that from the Click event of each option button.

[Aland2929]

I am not sure what I put after the = sign for the option buttons as what I have tried does not work?

Please Login or Register  to view this content.

Thanks in advance

[Norie]

Can you attach a workbook with an example form with option buttons?

[Aland2929]

Thank you.

[Norie]

Try this.

Please Login or Register  to view this content.

[Aland2929]

Thank you very much for your time and effort. I have tested your code on my test file and it works perfectly. I will now work through the code to understand it and then apply it to my real model.

[Aland2929]

I have used your code and added some extra options buttons and everything works perfectly. Thank you very much.