VBA issue in Excel 2019 for MAC

%3CLINGO-SUB%20id%3D%22lingo-sub-2263196%22%20slang%3D%22en-US%22%3EVBA%20issue%20in%20Excel%202019%20for%20MAC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2263196%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20doc%20that%20I%20have%20used%20for%20years%20on%20my%20PC.%20Recently%20I%20got%20a%20MAC%20and%20Office%202019%20for%20MAC.%20I%20opened%20the%20doc%2C%20and%20it%20would%20not%20function%20correctly%2C%20so%20I%20went%20back%20through%20all%20my%20formulas%20and%20etc%20to%20figure%20out%20what%20was%20up.%20The%20only%20thing%20I%20can%20find%20that%20is%20different%20is%20the%20VBA.%20I%20went%20to%20the%20developer%20screen%20to%20fix%20it%20and%20I%20get%20this%20error%3A%20%22Variable%20uses%20an%20Automation%20type%20not%20supported%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20basically%20have%20a%20bunch%20of%20searchable%20drop%20down%20boxes%20that%20auto-populate.%20So%20If%20I%20want%20to%20type%20%22tomatoes%22%20in%20a%20box%2C%20I%20just%20type%20%22to%22%20and%20I%20get%20a%20list%20of%20all%20the%20words%20with%20-to%20in%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20know%20how%20to%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2263196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

 

Anyone know how to fix this?

0 Replies