Userform wont open unless i comment out its line of code

[ipbr21054]

One thing after another.
I try to open my userform but i am told im unable to.
I debug the code and the date picker is shown in yellow.

I comment out that line of code & form opens.

What do i need to do to now fix this.

 

[NoSparks]

If you copied mscomct2.ocx from the Win 7 pc that's all you need.
If not see the second post here.

I put the ocx in C:\Program Files (x86)\Microsoft Office\Office12
Your picture show it was in C:\Windows\system32
It doesn't matter which it's in but it has to be registered with CMD run as administrator.
Make sure you use the correct path and you will get a message saying it was registered successfully.

 

[ipbr21054]

Im getting confused.
I cut the file mscomct2.ocx from the old Windows 7 pc.
I then put it into the same path as you mention, C:\Program Files (x86)\Microsoft Office\Office12

I then registered it the same way as you mention & i see the success message.
regsvr32 "C:\Program Files (x86)\Microsoft Office\Office12\mscomct2.ocx"


I open excel & toolbox but dont see the date picker so at this point i need to check mark

Its now im stuck,i think i need to check that item that was missing but i dont see it in tool s references

 

[ipbr21054]

Think ive done it.need to add control & tick date picker.

Now icon is shown

 

[ipbr21054]

Working as before.

Many thanks for the help once again

 

[NoSparks]

Good morning (7am here)
Almost abandoned this at post 8 but glad we got it sorted out.