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



--