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

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