User form macro

[Rsh]

Hi all,

I have a user form in which i have 4 check boxes. ok and cancel button.

when ever i click 1st check box, rows 1 to 10 should to be editable, 11 to 20 should be non editable and hide rest all rows till end.

For check box 2, rows 21 to 30 editable, 31 to 40 non editable, 1 to 20 and 41 till end should be in hide. I mean only 21 to 40 can be seen when i click check box 2.

Vice versa for button 3 and 4. How can i program it. Please help.

Many thanks,
Rsh

 

[Rsh]

Hi all,

I have a user form in which i have 4 check boxes. ok and cancel button.

when ever i click 1st check box, rows 1 to 10 should to be editable, 11 to 20 should be non editable and hide rest all rows till end.

For check box 2, rows 21 to 30 editable, 31 to 40 non editable, 1 to 20 and 41 till end should be in hide. I mean only 21 to 40 can be seen when i click check box 2.

Vice versa for button 3 and 4. How can i program it. Please help.

Many thanks,
Rsh

Please some one help with the above post