Option Button Trigger or changes depend on SUM()

[erdem_ustun]

Hi,
my first message

I have likert scales (1-5) that I created with Vba. There are groupbox in every row and include likert-scale(5 option buttons) in columns.
The number is quite over 100.
When you select each options, this options values writes the linked cell.

I want to ask;

1.WorkSheet_Change does not work when changes are made.

Linked cell change, no input from the keyboard, it does not perceive it as a change.


What can I do to make a selection-based calculation for each choice?


2. It is not logical to write click_event for each one because there are so many option buttons(more 100).


3. I can not do the above, I will sum up the whole column sum () at the end of Linked cell.


I want to make calculations depending on the sum () when any selection changes.(WorkSheet_Calculate)


4. I have a calculation, but now the calculations have started to take place and take too long if there is a calculation / formula anywhere in the worksheet.


For example
A1 = 1
B1 = 2
C1 = SUM (A1: B1)
How to check C1 cell and calculate C1 if it changes. There is no entry by hand. It comes from A1 and B1 options.

What can I do?

I look forward to your comments and help