Userform wont open unless i comment out its line of code

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,947
Office Version
  1. 2007
Platform
  1. Windows
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.


EaseUS_2025_02_17_21_07_53.jpg


I comment out that line of code & form opens.

What do i need to do to now fix this.

EaseUS_2025_02_17_21_02_09.jpg
 
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.
 
Upvote 0
Solution
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

EaseUS_2025_02_24_10_00_40.jpg


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

EaseUS_2025_02_24_10_03_53.jpg
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top