Design Best Practices: Form Control Code in Worksheet or Module

[Guest]

Which is best practice: Code for handling clicking of clicking of Form Button
on the worksheet where Button is placed, or in standard module? Both seem to
work but former approach seems to be more logical.

 

[Rob van Gelder]

Personal choice really...

If I think it's possible the logic might be used elsewhere, it goes into a
standard module.

I don't mind leaving small code bits in a worksheet, but if it gets more
than a couple of pages long I'll break it into a subroutine or function for
a standard module.

 

[Tom Ogilvy]

If you can't define the routine by selecting it from the dropdowns at the
top if the module (sheet module), then in general, it should go in a
standard module.