checkboxes enable and disable and assigning values and retreiving answers

[sharavanacn]

Hello Learned People,

I am a beginner in VBA. Kindly help me.

I have fifty checkboxes placed in the excel sheet and one text boxe and one command button.

Things to be done:

1. Using an array I need to divided these 50 checkboxes into 10 and on checking a checkboxes in each set, the rest four has to be disabled and resp. for the other 9 sets.

2. On clicking the command button the checked 10 checkboxes out of 50 has to be valued and diplayed in that text box.

Can any one help me in making the array.

Thanks,

Sharavana C N

[mdmackillop]

Hi,
Welcome to VBAX.
I posted a checkbox utility here which may be adapted to your use, but please note this is not a Mac entry.
http://vbaexpress.com/kb/getarticle.php?kb_id=114
Your request relies on layout etc. Can you post a copy of your spreadsheet? Use the Manage Attachment button found in the Go Advanced section.
Regards
MD