Getting "compile error" "method or data member not found" on reinstall
I have written a userform. My system crashed and had to be reformatted.
After installation, I started Excel checked ref under VB editor. I was missing 2 "missing: microsoft windows common controls-2 6.0 (SP4)" and also mccomctl.dll I have copied the first file from another system and it seemed to like it, I no longer got the missing on the mscomct2.ocx. I also reinstalled McAfee (the supplier of the the second one. I now have now "missing" entries, however I do get a "compile error" "method or data member not found" and it pops to an entry with a DTPicker varible ..DTPicker78 = ActiveCell.Offset(0, 77) This had worked before. I tried it back on the system I have been using for a backup, and it is NOT working anymore either! I did NOT make any code changes etc.... On a side note, when I go into the editor becuase of a trap, how can I get to the referances? I have been exiting out of the editor and then get a box that says "this command will stop the debugger" and then after returning to excel, reenter the editor. How else can I do this? Thanks B |
Getting "compile error" "method or data member not found" on reinstall
I resolved the issue by going to TOOLBOX, I did not set the DTPicker there,
so I needed to add it. Thanks Bruce "Bp" wrote in message news:tGYhc.5449$_L6.636273@attbi_s53... I have written a userform. My system crashed and had to be reformatted. After installation, I started Excel checked ref under VB editor. I was missing 2 "missing: microsoft windows common controls-2 6.0 (SP4)" and also mccomctl.dll I have copied the first file from another system and it seemed to like it, I no longer got the missing on the mscomct2.ocx. I also reinstalled McAfee (the supplier of the the second one. I now have now "missing" entries, however I do get a "compile error" "method or data member not found" and it pops to an entry with a DTPicker varible .DTPicker78 = ActiveCell.Offset(0, 77) This had worked before. I tried it back on the system I have been using for a backup, and it is NOT working anymore either! I did NOT make any code changes etc.... On a side note, when I go into the editor becuase of a trap, how can I get to the referances? I have been exiting out of the editor and then get a box that says "this command will stop the debugger" and then after returning to excel, reenter the editor. How else can I do this? Thanks B |
All times are GMT +1. The time now is 06:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com