Radio Buttons

[Saxman]

Would it be possible to add 3 radio buttons namely C, D, CD in cells A1,A2,A3 as
part of a group (so only one choice can be selected) and award points in adjacent
cells B1:B3?

C gets 10 points.
D = 10
CD = 22

TIA.
--

 

[Bob Phillips]

Add a frame from the forms toolbar, than add the 3 buttons into that.

Link the buttons (Format control>Control) to the same cell, and the formulae
become

B1: =(H1=1)*10
B2: =(H1=2)*10
B3: =(H1=3)*22

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Saxman]

Add a frame from the forms toolbar, than add the 3 buttons into that.

Link the buttons (Format control>Control) to the same cell, and the formulae become

B1: =(H1=1)*10
B2: =(H1=2)*10
B3: =(H1=3)*22

I am able to create a frame and add my radio buttons and link them as a group, but
I'm not sure of the proceedure linking them to a cell and adding the formulae?

Excuse me as I only have experience of VB outside Excel

(Format control>Control) I do not see an option 'control on my drop-down list within
Excel 2007.

Where can I find some good tutorials/information regarding Excel/VB in situations
like this?

Thanks so much for the feedback.



--

 

[Bob Phillips]

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I am able to create a frame and add my radio buttons and link them as a
group, but
I'm not sure of the proceedure linking them to a cell and adding the
formulae?

Excuse me as I only have experience of VB outside Excel

It's not VB, just pure Excel.

(Format control>Control) I do not see an option 'control on my drop-down
list within
Excel 2007.

What drop-down? we are talking frames and optionbuttons, not drop-down.
Right-click the buttons to see Format Control.