Excel automation errors with arrays in office 365

I am still working with dropdown comboboxes that are in the attached file. These work great in Excel Office 2019 where I create my excel vba files, but when I move these to either office 365 excel 32 bit or 64 bit, (one laptop wit excel 32 bit and another with excel 64 bit), it fails with Automation errors trying to utilize the dropdown list functions. I also get additional errors. Please see all attached files.

I have looked for any libraries that perhaps need added to excel office 365 to support the arrays / lists that are used in the combobox focus routine, but have been so far unsuccessful in finding any add-in for office 365. Does anyone know if there is a solution for these problems in office 365 or is this just not supported?

I'm using Office 365, and I have no issue with "System.Collections.ArrayList". And I didn't add any library or reference to make it work.
But if you want I can replace "System.Collections.ArrayList" with "scripting.dictionary" in your code.
But let's see if "scripting.dictionary" works on your system.

Please Login or Register  to view this content.

I tried the "scripting.distionary" in both the office 365, 32 and 64 bit versions. It does work. I have also attached some additional snapshots showing version info and various add-ins. One thing that I did not mention earlier, is that this off 365 is the home version on these laptops, so I am not sure if that might make a difference or not.

Thank you for your help.