0

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.

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
Paul Martin
  • 17
  • 4

1 Answers1

0

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.

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
  • Thanks, Pᴇʜ. That will have to do. I find it strange that Excel hasn't updated these objects. – Paul Martin Jun 23 '21 at 16:36
  • @PaulMartin They didn't because ActiveX is a dead technique. They are just there for compatibility reasons to old versions. – Pᴇʜ Jun 23 '21 at 17:05