TreeView Control - Library Not Registered

[Stephy]

I am trying to access the TreeView Control in Excel VBA but I am getting an error prompt "Library not registered". Can someone help me please.



Thanks...

[Debaser]

How are you trying to access it?

[Stephy]

Hi Debaser,

I added the TreeView Control version 6.0 via the Additional Controls option under the Tools Tab in VBA. The TreeView icon appears in the toolbox but once I click on it to draw it on my userform, I get the error message that the Library is not registered.

I have looked on the internet for possible solutions. I have unregistered and re-registered the MSCOMCTL.OCX file in SysWow64 with elevated privileges and I am still not getting pass this error prompt.

I am stumped!

Cheers,

[Debaser]

Do you have 64bit Office as well as 64bit Windows?

[Stephy]

yes... 64 bit processor and 64 bit system

[Debaser]

Not processor - is Office 64bit? If so, you cannot use the Treeview control, or any of the Windows Common Controls.

[Stephy]

Where do I go to know if it is 64bit Office? When I check the properties of "This PC" it says:

System Type: 64-bit Operating System, x64-bit-based processor

[Debaser]

I can't recall exactly where it is in 2013 - under File - Account or something similar, it should show your Office version and build number including whether it's 32 or 64bit.