Link this code to a checkbox

[zanguard80]

I have this code:

Please Login or Register  to view this content.

That puts the row number of the active cell in A1. However, when it is enabled, I can't undo anything or paste to the worksheets. How do I link this to a checkbox (i.e., when the checkbox is ticked, the above code should be active and when it is unticked, it should be inactive).

Thanks in advance!

[Leith Ross]

Hello zanguard80,

When using either the Change or SelectionChange event, modifying a cell or a range will trigger the event again. This will lock up Excel or crash it.

To prevent this, you need to suspend responding to events until your macro is complete. Events need to be re-enabled before you exit the macro or before the macro finishes.

Here is how to do it...

Please Login or Register  to view this content.

[Mad-Mizer]

Have you tried using ActiveX controls for your check boxes? They are super easy to code and function well.