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.
--

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

Link the buttons (Format controlControl) 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" wrote in message
...

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 wrote:

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

Link the buttons (Format controlControl) 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 controlControl) 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.



--

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

"Saxman" wrote in message
...
Bob Phillips wrote:

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

Link the buttons (Format controlControl) 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


It's not VB, just pure Excel.


(Format controlControl) 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.


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

Thanks so much for the feedback.



--