COST CALCULATOR
 

I AM TRYING TO CREATE AN INTERACTIVE CALCULATOR FOR EMPLOYEES TO USE FOR
BENEFITS OPEN ENROLLMENT. I WANT THE EMPLOYEE TO SELECT A RADIO BUTTON
ASSOCIATED W/THE COST OF EACH BENEFIT THEY WANT. HOW DO I GET THE RADIO
BUTTON TO REFERENCE A CELL WITH A PREMIUM IN IT?

COST CALCULATOR
 

There are three kinds of radio buttons in Excel. 1. Forms toolbar 2.
Controls Toolbox toolbar. 3. UserForms. The first two kind go on
worksheets and have a cell link or linked cell property. The third has
a ControlSource property that can link to a cell. The value in the
cell is true/false or a number indicating which one of a set of
buttons is elected. So the cell could not have a premium in it, but
you might devise a way to decide the premium based on what is in the
linked cell(s).

Hth,
Merjet