linking radio button

[paritoshmehta]

hi,

I wanted to link 4 radio buttons to a sheet in a way that if the firs
one is selected, the linked cell, say a1 has a value 1 and if the 2n
button is selected, a1 has a value 2 and so on....

any help is greatly appreciated!

 

[Tom Ogilvy]

Use optionbuttons from the forms toolbar with a groupbox and this will be
the default behavior.