I've got the answer (all credit to a user at stackover.com)

The regex which does the above described task is (among others I assume):

[VBA]^.*?SEARCH_TERM_\#1((??!SEARCH-TERM_\#2|SEARCH-TERM_\#3).)*)[/VBA]