The index is in the property list of a radiobutton.
if you group several radio buttons you give each of them a differen
index value and then you can use the select case... code.
select case frame.value
case 1
dep.value = " 45 "
case2
dep.value = " 65 "

end selec

--
panamarenc
-----------------------------------------------------------------------
panamarenco's Profile: http://www.excelforum.com/member.php...fo&userid=1473
View this thread: http://www.excelforum.com/showthread.php?threadid=26359