ActiveX controls in Excel 2013 64 bit

Question

I've developed a number of excel tools which include ActiveX controls from the developer tab and VBA. They all work in Excel 2013 32 bit. However one of my clients is using Excel 2013 64 bit and the tools do not function on his PC. I understand that this is probably due to the ActiveX controls. (https://technet.microsoft.com/en-us/library/ee681792.aspx)

is there a simple way to make my tools excel 2013 64 bit compatible? preferably without having to install office 2013 64 bit and having to re-work them all?

You made ActiveX controls? Or you made tools using ActiveX controls? — Mathieu Guindon
@Mat'sMug I made tools using ActiveX controls. Using the Developer tab and Insert to add them to a worksheet. the're all simple ones like comboboxes and Listboxes, but with vba code behind them. — Oliver Humphreys
Per the MSDN article you linked, you're going to need to maintain and ship 32 and 64 bit versions. — Mathieu Guindon
Is there a particular reason you used ActiveX controls rather than normal form controls? Perhaps to use their events? If not then you can programatically replace them all with form controls. — Absinthe

John Erwyn Smith John Erwyn Smith · Accepted Answer · 2020-12-30T20:39:22

ActiveX has more controls, with other options.

Excel 2013 x64: Doesn't have "SerialPort" in form controls. is an activex control

ActiveX controls in Excel 2013 64 bit

1 Answers