Can a macro call Worksheet VBA Code

[DogsbodyBoy]

My understanding is that VBA code on a worksheet (right-click on Worksheet table and select View Code) will run automatically every time a value is entered into the active cell and then accepted with the enter key. Is it possible to have the VBA code on the worksheet called from a macro so that it runs on the active cell at the time the macro calls it? I guess another way of wording the question is to say that I want the macro to replicate hitting the enter key so the Worksheet VBA code then runs.

Thanks for any help.

 

[RoryA]

The best way to do that would be to put the routine into a normal module and have it called both from your worksheet event code and from your macro.

 

[DogsbodyBoy]

Thanks, Rory. I was thinking too deep; your suggestion is the correct approach.