I have an Excel doc that I have used for years on my PC. Recently I got a MAC and Office 2019 for MAC. I opened the doc, and it would not function correctly, so I went back through all my formulas and etc to figure out what was up. The only thing I can find that is different is the VBA. I went to the developer screen to fix it and I get this error: "Variable uses an Automation type not supported"
I basically have a bunch of searchable drop down boxes that auto-populate. So If I want to type "tomatoes" in a box, I just type "to" and I get a list of all the words with -to in them.