You will have check each pc and look in references and see if it is marked as missing. Another option, is to implement a date picker in your code.
Attached Files frmCalendarv1. Re: Date Picker not available You have that problem because the Datepicker is not installed on the PC of your co-workers.
From office , the datepicker is no longer supported. Good advice, forget the datepicker, you will only get problems with it as you have experienced it yourself.
Re: Date Picker not available Thanks dotchiejack, for your help however i cant install it this way to all user i found an alternative code for calender, but i cant use it in my form could you please help with this? Sorry for being dumb the calender code is attached in my previous reply. I sent tge instructions to one user. Re: Date Picker not available See attached.
Calendar opens in textbox 2 and 3 when you enter the boxes. Drag the calendar form to your file. Have a look at my code and the names of my controls. To adjust the code look also in the class module.
There are 2 options buttons, they are used to select the correct textbox, you can hide the frame with the 2 options buttons. Attached Files Calendar 2 textboxes. Re: Date Picker not available For this,try, when your Windows is 64bit. I would advise you to create your own simple " Calender " control by using standart ActiveX objects Userform, Label, CommandButton, etc.
Re: Date Picker not available is the month viewer available to you in the vba toolbox???? Re: Date Picker not available i need calender and time picker, i gave up , gonna use normal textbox. Re: Date Picker not available If you are going to use text boxes the attached may be of use. It enables just the numeric pad to be used for speed data entry eliminates the need to enter separators.
Attached Files timedur. Originally Posted by torachan. If you are going to use text boxes the attached may be of use. Re: Date Picker not available This is now resolved.
It was still there on UserForm3. Ali Enthusiastic self-taught user of MS Excel who's always learning! Forum Rules updated September : please read them here. Take a Class module, put most of the VBA code into it. Mix it with your application. Take out the decayed items, replace it with the new, freshly-cooked one, served in a simple frame! All of your applications will easily digest it! Open your project and the Calendar Class file, copy drag-and-drop the cCalendar Class module into your project.
This copy works between two different Office applications too! Now you have a new class module in your project with name cCalendar. You can change the name in the Properties window if you want. In this case, you have to use this new name in the following codes instead of cCalendar. You need to create an empty frame control on your form where the Calendar Class will be placed.
Move and resize the frame to the desired place of the Calendar. You can change the name of the frame in the Properties window if you want. In the below code rows the frame is named Frame1. If you re-named your frame, please write the exact name instead of Frame1. I have a new Windows 10 laptop with Excel I need to support a spreadsheet that has a datetime picker. When I start the spreadsheet, I get an error 'Could not load an object because it is not available on this machine.
Update Download Apk Photoshop. Free Nine Patch Quilt Patterns. Specifies text that appears when the user briefly holds the mouse pointer over a control without clicking. Sets the current month. Must be a value between 1 January and 12 December.
