I am using Option Buttons and having them return a single number
value to Excel cell L10, where the value reflects the option that has
been selected.

I have set up a macro with a case statement, which starts as below:


Sheets("Index").Select
Select Case Range("L10")

Case Is = 0
End

Case Is = 1
Sheets("Chart of Accounts").Select
Range("BB3").Select

...more cases will follow...


This works when I click a macro button which has the macro assigned
to it, but what I really would like would be for the action to take
place automatically when clicking on the selected option button. Is
this possible, and if so, how would I do it? Thanks again in advance
for any help that you can give me.

I know this is ambiguous, but I am using "macro button" to mean the
rectangular top LEFT BUTTON in Form Controls, and "option button" to
mean the round top RIGHT BUTTON in Form Controls. Hope this helps.