If you do not do this, Excel VBA will highlight every member related to ListView with the message "Compile error: User-defined type not defined". To use the specific ListView control types and properties in VBA code (like the ListView type itself, the LabelEdit and CheckBoxes properties, the lvwAutomatic named constant and the like), you need to add the reference to the MSComctlLib type library implemented in the same MSCOMCTL.OCX file to your Excel VBA project. One important thing related to this code and any other code manipulating the ListView control in Excel VBA is the following. ' Set ListView properties through the objListView reference Set objListView = ThisWorkbook.Sheets(1).OLEObjects.Add( _ĬlassType:="MSComctlLib.ListViewCtrl.2", _
The essential part of the suggested code solution looks like the following: ' Create a ListView control in VBA code To avoid these issues in production code executing on the computers of your clients, you can try to Create ListView in VBA at Runtime. Many developers experienced problems with instantiating common controls like ListView on Excel worksheets after recent updates in the Windows and Office products even if the Windows common controls OCX was registered correctly. Fortunately for all us, we can still download the Microsoft Visual Basic 6.0 Common Controls redistributable package including ListView from this page on Microsoft’s website. ListView Common Control (mscomctl.ocx) not installed under Excel 2016 / Windows10Īs you can also conclude after reading this post, the ListView control may be absent in the latest version of Microsoft Office and Windows. For more info, read the following StackOverflow post:
This OCX is a 32-bit executable file, and it must be placed in the SysWoW64 system directory but not in System32 in 64-bit versions of Windows. Pay attention to the location of MSCOMCTL.OCX in the Additional Controls dialog.
0 kommentar(er)
