Thread: Radio Buttons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Radio Buttons

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