VBA

[anandbw82]

Hi all,

can anybody suggest that what is the difference between writing VBA code in worksheet code window and module code window.

suggestions will be appreciated.

[Bob Phillips]

The worksheet code module is to hold code that would pertain directly to that sheet, usually triggered b y some worksheet event.

The standard code module is more generic, and can be used by procedures in This Workbook, a worksheet, a form, a class, or just other procedures in standard code modules.

[CreganTur]

There is a very big differenece, and that difference has to do with the scope of the code.

Code behind a worksheet is only available for use by that worksheet, but code placed into a module can be called from any worksheet.

[Simon Lloyd]

Threads merged, anandbw82 please only post one thread per question.

[Bob Phillips]

Code behind a worksheet is only available for use by that worksheet, but code placed into a module can be called from any worksheet.

Not absolutely correct, you can access a procedure in a worksheet code module if it is public in scope byh preceding with the worksheet codename.