If a radiobutton is grouped you can give each of them a different inde
value and then use the case code as illustrated below.
In VB excel I cab't find the index item in the option list of
radiobutton.



select case frame1.value

case 1
Dep.value = " 45 "
case 2
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