CONNECT VBA: List Control and the MsComCtrl.ocx

MicroStation V8i provides 32-bit VBA v6.5.   As any other implementation of VBA (e.g. Microsoft Office), that lets you reference other 32-bit DLLs.  Another name is OCX, when the DLL delivers a user-interface (UI) component.  A popular OCX is the MsComCtrl.ocx, which contains a number of components that make VBA better.  Many chose to use the ListCtrl (List view control), which offers several benefits over the ListBox delivered with VBA.

MsComCtrl.ocx — 32-bit Only

Then 64-bit Windows arrived, around the turn of the century.  Bentley Systems released MicroStation CONNECT in 2015.  MicroStation CONNECT provides 64-bit VBA v7.1.  Most VBA macros run without change when transferred from V8i to CONNECT.  Some that don't run include those that use a ListCtrl.  Why?  Because Microsoft didn't provide a 64-bit version of MsComCtrl.ocx.

Office 365 and Office 2019

Microsoft Office is available in both 32-bit and 64-bit versions.   Install the 64-bit version of Office 365 or later, and you will find a 64-bit version of MsComCtrl.ocx.  Add the ListCtrl to your VBA toolbox, and you can once again craft a superior list viewer.

Anonymous