Userform wont open unless i comment out its line of code

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,934
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
 
The Date picker isnt on my formIts not in the toolbox.
I have it on my other pc so can i copy that file & put on new pc for it to then be shown in the tool box ?

Thanks
 
Upvote 0
I seen that but wont work.
Im seeing about another option for a date on my form but will remember the link you posted
 
Upvote 0
Plan B isn't getting a lot of response and
I seen that but wont work.
doesn't even give a hint as to what the situation might be.

I took an empty hdd and clean installed Windows 10.
Then installed MS Office Home and Student 2007, only Excel and Word.

MSCAL.OCX was nowhere to be found so copied it from an Office 2003 installation
and pasted into C:\Program Files (x86)\Microsoft Office\Office12

Then hit the Windows Key and typed cmd
clicked Run as administrator
typed in
regsvr32 "C:\Program Files (x86)\Microsoft Office\Office12\MSCAL.OCX"

got the success message and could then add calendar control to the tool box.
 
Upvote 0

Forum statistics

Threads
1,226,837
Messages
6,193,254
Members
453,784
Latest member
Chandni

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