I have a VBA project which runs perfectly upto windows 7 (both 32,64 bit) and upto office 2010. But when i try to run it on office 2013 or 2016. It does not load treeview control and gives error at:
Private SelectedNode As MSComctlLib.node
The things i have already tried are:
-
Followed this post thoroughly
http://thesmileycoder.com/treeview-working-in-access2013/ -
Re-registered MSCOMCTL.OCX/MSCOMCT2.OCX several times on both SYSTEM32 and SYSWOW64 folders.
Any help is appriciated!
Best Answer
Thanks for clarifying that you're using Office 64-bit.
You should see this article
Specifically the section:
Followed by:
EDIT And this page for 2010 spells it out in more detail: