Cant add ListView to toolbox in VBA

Cant add ListView to toolbox in VBA

CadUser46
Collaborator Collaborator
1,054 Views
2 Replies
Message 1 of 3

Cant add ListView to toolbox in VBA

CadUser46
Collaborator
Collaborator

I need to use a ListView on a userform.  Only problem is that i cannot enable it in the IDE in Inventor.

 

I have confirmed the file mscomctl.ocx exists at C:\Windows\SysWOW64

I have reregistered the file using CMD (as admin) regsvr32 c:\windows\syswow64\mscomctl.ocx

I have added mscomctl.ocx as a reference.  ie ticked 'Microsoft Windows Common Controls 6.0 (SP4)'

 

I still do not see Microsoft ListView Control in my list of available controls when in Inventor.  Works fine in Excel.

Why don't i see it, and what if any is the alternative?


Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

---------------------------------------------------------------------------------------------------------------------------
Inventor 2010 Certified Professional
Currently using 2023 Pro
0 Likes
1,055 Views
2 Replies
Replies (2)
Message 2 of 3

tobias.orlow
Alumni
Alumni

Hi @CadUser46 ,

 

I'm guessing it could have to do with the bitness, Inventor is 64bit and so is the hosted VBA IDE within it.

Just to confirm, can you please check if your Excel/Office installation is 32bit?

Also, as an alternative, would a ListBox control work for you instead?

 

Thanks in advance!

Tobias

Tobias Orlow
Designated Support Specialist
Customer Success Organization
Linkedin: www.linkedin.com/in/tobiasorlow/
Message 3 of 3

CadUser46
Collaborator
Collaborator

Now that you say that, that could be it.  I've read that it does not function in 64bit Office to it would make sense it also does not in other 64bit apps.

 

In my case Office is 32bit.

 

I've started down the road of a multi column ListBox like you suggest.  I really just need scrollable columnar data but it would have been nice to have other features.


Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

---------------------------------------------------------------------------------------------------------------------------
Inventor 2010 Certified Professional
Currently using 2023 Pro