Hello everyone, I want a VBA code to identify abbreviaions using regex that follows some patterns and add them into a text box at botoom of each slide. Some of the conditions for which the regex should find a match are as follows : -
- More than one consecutive capital letter
- One or more than one consecutive capital letter followed by - or one or more digits
- Group of more than one consecutive capital letter with one or more small letters in between, example, P&R, MenB
- One or more than one consecutive capital letter in brackets
- A group of letters with - in between and non whitspace at beginning and at end
- One or more than one consecutive capital letter followed by a - followed by one or more digits
- A small letter immediately followed by one or more capital letters
- More than one consecutive capital letters with a / in between
Also, here are few exmples of abbreviations that I want the regex pattern to identify: COVID-19, COVID19, EU5, P&R, Q4, mRNA, pPCV, SARS-CoV-2, (CPI), PCV13, MenACWY, PCV10, G-ba, G-bA, N/A, P&MA, MenB