Help using active x option box

Hello all,

I have created a basic example which hopefully I can relate to my project at work.

I need to select one or more options (hat, tie, shoe) and then have whatever is selected add together in my tables total row

Test 1.PNG

Any ideas?

Hi there,

Given that you are using radio buttons, I assume it will always only be one option.
Using the Form Control radio button, you don't need any VBA for that.
Link the 3 buttons to one cell, which then controls the formula to sum your data.

Many thanks for the reply, I do need to use combinations of more than one. What is best to do this?

Have you considered using Slicers?

I don't think that is going to work. In my master workfile the table is hidden from view as the data in it is used elsewhere in a calculation. All the user see's are the product options. At the minute this is done by a drop down list which covers all the combinations and then the table has all combinations added together. I then use vlookup to select the row I require based on the drop down list selection and I can then use this data elsewhere in my file. If the product options could be selected and the total row could add them together based on the selections then this would make the file easier to update in the future.

Can it be achieved using checkboxes?

Using checkboxes.
macro on each checkbox

Perfect, Many thanks.

As mentioned above, radio buttons allow only one selection. For multiple choice, use Tick-Boxes.
Each Tick-Box is linked to a separate cell and will return True/False. You can move the tick-boxes on top to hid it.
We then simply use the Sumifs function and sum up where the value is True.