store chkbox.caption of selected checkboxes only in array.

suppose..
chkbox1.caption is = FARES
chkbox2.caption is = RULES
chkbox3.caption is = ZONES
chkbox4.caption is = CONDITIONS
chkbox5.caption is = ROUTING

now below are chkbox selected from above..
chkbox1
chkbox3
chkbox4

get the name of selected chkboxes and store as...
MyArray = Array("FARES", "ZONES", "CONDITIONS"

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=37703