Using Loop on CheckBox

[Jimmyzai]

Please Login or Register  to view this content.

With the code above, I manage to assign value to cell in sheet "database" according to the condition of the checkbox. However, if there is 30 checkbox, I would like to introduce looping as typing all these line by line would be very time consuming. I think this is possible as there is a pattern.

Hopefully somebody would enlighten me. Thanks

[rylo]

Hi

Where are the checkboxes? On a form, or directly on the sheet?

rylo

[Jimmyzai]

It's directly on the sheet

[rylo]

Hi

Why not use the linked cell property to put the result directly where it has to go?

rylo

[Jimmyzai]

The thing is the link cell is in another worksheet and the cell is not specific as it depends on the number of time the loop is done.

[rylo]

Hi

You could put a macro in the general module like

Please Login or Register  to view this content.

then the macro for each combobox would be like

Please Login or Register  to view this content.

Note that as there is nothing going into column A of the output sheet, if the same checkbox is called multiple times, the it will continue to overwrite the output.

If you want to loop through all the comboboxes on the sheet, then that could be done, but you would need some way to trigger the macro. How would that be done?

rylo

[Jimmyzai]

Yeap, I am also wondering about this for a long time.