Call Public Sub From Worksheet VBA

[jo15765]

I am using the

Please Login or Register  to view this content.

event, and rather than copy/paste code from a module into the worksheet event, I was wondering if I could call my event

Please Login or Register  to view this content.

from the Worksheet?

Obviously the _SelectionChange is in the VBA for a worksheet, and GetIt() is in a standard module.

[JBeaucaire]

Yes, you can call public sub routines from a private event.

[jo15765]

Yes, you can call public sub routines from a private event.

Would I just call it like so

Please Login or Register  to view this content.

[ferday]

just

Please Login or Register  to view this content.

it's redundant but i always use Call since it's closer to OOP and less ambiguous

Please Login or Register  to view this content.