PDA

View Full Version : [SOLVED:] All userform controls are "not" working



JKwan
04-14-2023, 08:10 AM
I only recently found out with the problem, so I don't know when it started to happen..... I usually do all my work with my work laptop, now that I am retired, I am now using my own computer. I can add the textbox control onto my form it runs and all but if I try to move the text box, i get the above message, so I cannot move it.... However, if I use the Treeview control, it sort of works. It runs but if I try to add some nodes, it fails with an error saying that the property or method is not supported... Hopefully someone can give me an in sight as to how I may fix the problem. I checked the Treeview control, the DLL does exists in the listed folder.




I am using Office 2019 Professional

Paul_Hossler
04-14-2023, 04:50 PM
A number of userform controls do not work in 64 bit office, which I think you're using. This might have changed for some but IIRC TreeView was not one of them

https://learn.microsoft.com/en-us/answers/questions/860672/vba-excel-2016-msi-64-bit-problem-with-listview-el


https://sourceforge.net/p/ol-lookfordups/wiki/Microsoft%20Windows%20Common%20Controls/


Microsoft Windows Common Controls

Microsoft Windows Common Controls provide features like ListView, TreeView, and ImageList, which are partly necessary for the interface of OL [LookForDuplicates] (https://sourceforge.net/p/ol-lookfordups/wiki/LookForDuplicates/). The filename of the corresponding control is mscomctl.ocx and it resides in the system32 folder.
You can download mscomctl.ocx directly from Microsoft (http://activex.microsoft.com/controls/vb6/mscomctl.cab).
After decompressing into C:\WINDOWS\system32\ you need to register the control by running
regsvr32 C:\WINDOWS\system32\MSCOMCTL.OCX
in the Windows Run dialog ([Win]+R). In order to be available for OL [LookForDuplicates] (https://sourceforge.net/p/ol-lookfordups/wiki/LookForDuplicates/), the library has to be loaded in Outlook according to the Installation guide (https://sourceforge.net/p/ol-lookfordups/wiki/Installation#Loadingrequiredlibraries).
Additionally, you can have a look at the Microsoft Download Center (http://www.microsoft.com/downloads/details.aspx?familyid=25437d98-51d0-41c1-bb14-64662f5f62fe) for an updated version of the control.
It should be noted that Microsoft Windows Common Controls are only available for 32-bit editions (https://sourceforge.net/p/ol-lookfordups/wiki/Requirements/#note-for-64-bit-editions-of-microsoft-office-outlook) of Microsoft Office Outlook.

JKwan
04-15-2023, 06:03 AM
Hi Paul:
Thank you for the suggestions, however, I am using 32 bit office. Since this is my home PC, running 64 bit is too much of a hassle, so I am running 32 bit and I confirmed. I hope you can offer more suggestions.
I like to stress that ALL of the controls that I put into the form, they can be added and run (mostly), just if I try to move it, I get the "System cannot fine the file specified"!!????

georgiboy
04-17-2023, 01:07 AM
The below thread seems to have some bits to try:
https://answers.microsoft.com/en-us/msoffice/forum/all/controls-on-user-forms-suddenly-cant-be-dragged/782fff07-aeac-4b08-8c6d-d8916ed8a989

JKwan
04-17-2023, 11:55 AM
Thanks georgiboy. Reading the thread, the person seemed to have the same problem that I am having, the person seem to have the problem to go away after a reboot, as to myself, I am stuck with reboots. I have the problem even when I create a new form and drop controls on to the form, the form runs and resize and all, just does not let me move it..... I may have to live with it. To be honest, it is not that big of a deal, since I am just "playing" now.... Thank you again.