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

--
Regards,
Tom Ogilvy

"paritoshmehta " wrote in
message ...
hi,

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

any help is greatly appreciated!!


---
Message posted from http://www.ExcelForum.com/