HELP-Custom Abbreviator program in VBA

[gjk92]

Hi,

I am trying to improve one of my databases.
I need some assistance in writing a Custom Abbreviator program in VBA to go trough a table with custom abbreviations and then search another table with a strings like "East Emergency Exit 0123" and when i run the abbreviator it should save "E/EME/EX 0123" to a new table. I would like to use this for labeling purposes.

Abbreviation Table
EAST - E
WEST - W
EMERGENCY - EME
EXIT - EX
etc.

Currently my code sucks and is not working - what a surprise.
Any help would be appreciated.
THANKS

[orange]

Please post a link to your abbreviations. Or provide a list.