I have worksheet ActiveX ComboBoxes in my file (Excel VBA 2019) that are not working on a Mac computer. Is there any way that I can get these to work on a Mac?
I know I can use Form Controls that will work on a Mac, but a Forms ComboBox doesn't allow me to center the alignment of the text in the drop-down.
Any suggestions appreciated.
ActiveX is an obsolet old Windows technology that is not available on Mac and is recommended to avoid in Windows. Further sources: Enable ActiveX on MacOS?
ActiveX is known to have many bugs and cause many strange issues in Windows. I would stay away from it as far as possible and use alternatives.
The solution is using Form Controls.