sharavanacn
03-05-2006, 06:31 AM
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
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