Monthly Archives: Feb 2023

VBA Application methods compatibility in Excel and Access

Posted on Feb 17, 2023 by Patrick O'Beirne, Excel/VBA developer

When working on VBA code that should work in both MSExcel and MSAccess VBA, the different application object methods can be hard to manage. For example, Application.Screenupdating = False is used in Excel but would raise a compile error in … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

Excel formula to test if a word contains certain letters

Posted on Feb 8, 2023 by Patrick O'Beirne, Excel/VBA developer

Victor Momoh in the Global Excel Summit, to start a discussion on readability, provocatively used MMULT in a formula to determine whether a word contains all five vowels.  As Victor said, in real life he’d use a simple SUM:=SUM(1*ISNUMBER(SEARCH(MID(“aeiou”,SEQUENCE(1,5),1),A2))) SEQUENCE generates … Continue reading →

Posted in Excel/VBA | 7 Comments