Show next checkbox when I click previous one

[bambino_32]

I have multiple check box (activex control).
When click to first check box second should appear and linked to corresponding cell in column K.
I did that manually
Is here the way to do tah using more complex code

==============================
My code
==============================

Please Login or Register  to view this content.

and so on. I'm very tired and want to go home pls help..

Mery chrisymas

[Palmetto]

Is here the way to do tah using more complex code

Code should never be more complex than what is required to efficiently achieve the result.

Although I have no context for understanding your project, I see nothing wrong your approach in making checkboxes progressively appear. However, you might want to include code to hide successive check boxes if the user unchecks the previous checkbox.

[bambino_32]

Is that true way to do that. For exxample I have 100 checkboxes, and I have to write this code for each check box separately?

When I told comlex code , I meant shrter one

[Palmetto]

OK, now I see what you intended.

I would NOT use a checkbox control at all. It is much easier and there is less code if you opt for using a Marlett check box. It also permits a cleaner looking worksheet.

See this link on using a Marlett Checkbox

[Leith Ross]

Hello Bambino_32,

There are 2 macros here. The first macro will be called by the check boxes to perform the actions you require. The second macro will automatically create the code for each check box. The aonly requirement is the check box names must start with "CheckBox1" and progress sequentially up to "CheckBox100". You can change the limit of 100 to some other number if want. Copy this code into a separate VB module. Make sure the worksheet that has the check boxes is the active sheet.

Please Login or Register  to view this content.