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

Excel VBA doesn't support control arrays.

--
Regards,
Tom Ogilvy


"panamarenco" wrote in message
...

If a radiobutton is grouped you can give each of them a different index
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 a
radiobutton.



select case frame1.value

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