Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design Best Practices: Form Control Code in Worksheet or Module
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design Best Practices: Form Control Code in Worksheet or Module
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. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Bing" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Design Best Practices: Form Control Code in Worksheet or Module
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. -- Regards, Tom Ogilvy "Bing" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where?Worksheet code module or Worksheet_SelectionChange event han | Excel Worksheet Functions | |||
Worksheet form design | Excel Discussion (Misc queries) | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Updating form labels from code in a module | Excel Programming | |||
Problem copying worksheet containing code module | Excel Programming |