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

Excel VBA doesn't support control arrays.

--
regards,
Tom Ogilvy

"panamarenco" wrote in message
...

The index is in the property list of a radiobutton.
if you group several radio buttons you give each of them a different
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 select


--
panamarenco
------------------------------------------------------------------------
panamarenco's Profile:
http://www.excelforum.com/member.php...o&userid=14738
View this thread: http://www.excelforum.com/showthread...hreadid=263595