Checkbox inquiry

[Luaptar]

Hi,

Good Morning!
Been trying to browse the web for answers but only macros were available.
I wanted to have 3 checkboxes linked to 1 cell.

Cell A1 as the result cell.

If I tick checkbox 1, A1 = 50
If I tick checkbox 2, A1 = 100
If I tick checkbox 3, A1 = 150


I hope somebody can help me with this using excel formulas only. Still learning how to use macros as formulas.

Thanks,
Luaptar.

 

[mikerickson]

Do you want check boxes or option buttons?
The main difference is that only one option button can be checked at the same time.
If you want checkboxes, what do you want to be in A1 when two buttons are checked? the sum of their amounts?

For checkboxes, get three checkboxes from the Forms Menu, not ActiveX controls.
Right click on each checkbox and format each control. On the Control tab, link Check Box 1 to $B$1, Check Box 2 to $B$2 and Check Box 3 to $B$3

Then in A1, put the formula =50*B1+100*B2+150*B3.
Done. (If you want something other than the sum when multiple checked boxes are checked, the formula will be different.)

For Option Buttons, again get three of them from the Forms Menu.
Link any one of those Radio Buttons to the cell $C$1

Then the formula =50*C1 in A1 will do the job.

 

[Luaptar]

Hi Mikerickson,

I actually want some option buttons that:
All checkboxes is linked to Cell A1
If I tick Checkbox 1, A1 = 50 but will automatically disable checkbox 2 & 3.
This goes for all checkboxes.

Is this possible using excel formulas only?

 

[mikerickson]

No. Disabeling the checkboxes requires VBA. (How did you plan to re-activate the controls)