Adding Similar code to a Private Sub Worksheet_Calculate()

[singerbatfink]

Hi Im trying to add another sequence of code to this Private Sub Worksheet_Calculate.

I only need to change

Please Login or Register  to view this content.

to F501

and

Please Login or Register  to view this content.

to CAll AWC but dont know how to insert these new lines and trigger a new macro.

Please Login or Register  to view this content.

[Greg M]

Hi there,

Take a look at the attached workbook and see if I've understood your requirements correctly. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


In the above code I've used Call statements - this is a personal preference because the Application.Run method has shortcomings in certain circumstances, but if you want, you can replace the following:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

The Module-Level Constants "msMACRO_NAME_1" and "msMACRO_NAME_2" can then be defined instead as Procedure-Level constants in the "Worksheet_Calculate" procedure.

The above alternative approach assumes that the "WC" and AWC" routines are contained in the VBA CodeModule of the worksheet in question.


Hope this helps - please let me know how you get on.

Regards,

Greg M