Using a Date time picker in a VBA form

I'm having the same problem with DTPicker when trying to share an Excel file. I placed the Excel file on our server here at work and I'm the only person who can open it without any errors. I copied the mscomct2.ocx file to the same folder on the server, and tried to copy it to other compters who would need to use the Excel file....still can't find the DTPicker when adding tools to the toolbox in VBA.

Please see this old post

I would never use these controls, see some alternatives here There's a calendar form or a set of ComboBoxes that can be used

Thanks Roy for the link to the Add-Ins. I will have to try this alternative date picker and see how that works out.

Is there a way to tie the add-ins to the file so that the person opening the file with an add-in won't have to go to the Internet to D/L the add-in?

...edit: sorry about the tag on question to the other poster's thread. I'll be carefull in the future.

Use the ComboBox example or the CalendarForm example, not the addin

Originally Posted by jwright650

Thanks Roy for the link to the Add-Ins. I will have to try this alternative date picker and see how that works out.

Hi royUK,
D/L'd the Calendar Add-in, but I have an issue when I go under "Tools"/"JR Datepicker" >Show...it instantly gives me a run time error 9

I've just downloaded it & run it with no problem.

Which version of Excel are you using?

How did you load the addin?

Originally Posted by royUK

I've just downloaded it & run it with no problem.

Which version of Excel are you using?

How did you load the addin?

I'm using Excel 2003 on an XP machine.
I ran the xls file and then under Tools/Add-ins checked the box beside the JR_Datepicker. Then closed Excel. Went back in Excel and under Tools/JR_Datepicker_Show > the very second my mouse travels over the menu to fly out, it displays the runtime error 9. I followed the "automatic install" option first, then the "manual" option....neither seemed to make it work correctly.
Any ideas what I did wrong?

I can't duplicate the error

Hi royUK,
I'm going to delete it and D/L a fresh copy and see if that will work.

BTW, I D/L'd the zip file to a folder (C:/My Documents/Installs) where I copy most of the stuff that I D/L. Should that file be located somewhere else to install correctly? Excel had it listed in the list of Add-ins to show.

All you need to do is to extract the addin to a folder, usually have a folder on the C Drive & name it addins. keep all your addins there, then simply use Tools -> Addins & browse for the file

Used a calendar build VBA code instead....Thread is "Solved"