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:

If OptionLocal Then Range("Import") = "Local"
    If OptionImport Then Range("Import") = "Import"
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.