+ Reply to Thread
Results 1 to 15 of 15

Date Picker not available

  1. #1
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    239

    Date Picker not available

    Hellow everyone,

    i have created userform with date picker controls as shown , when i sent this file to work colleagues they couldnt see the date picker as shown in second pic
    and error message appeared
    "could not load some objects because they are not available on this machine"

    save.png

    date blank.png


    Operation form password : useropr
    Attached Files Attached Files
    Last edited by Mahmoudelnemr; 07-21-2019 at 11:32 PM.

  2. #2
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    378

    Re: Date Picker not available

    Latest office versions do not have date picker by default.
    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

  3. #3
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    239

    Re: Date Picker not available

    Quote Originally Posted by nordicdust View Post
    Latest office versions do not have date picker by default.
    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
    Iam new to vba , so i looked for calender code on google, found the attached one, however i cant copy it to my sheet it makes error
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Date Picker not available

    You have that problem because the Datepicker is not installed on the PC of your co-workers.
    From office 2016, the datepicker is no longer supported.
    Good advice, forget the datepicker, you will only get problems with it as you have experienced it yourself.
    If you still want to install the datepicker you first have to download and install MSCOMCT2.OCX.

    (1) Perform the function below on any computer that is missing the mscomct2.ocx
    (2) Make sure a copy is in C:\Windows\System32.
    (3) In the Search area, type "command" but DON'T Press Enter Yet
    (4) The search will bring up a number of items, including "Command Prompt" at the top
    (5) Right click the "Command Prompt" banner, and select "Run as Administrator".
    (6) At the command prompt, enter: %systemroot%\System32\regsvr32.exe mscomct2.ocx
    (7) This should successfully register your legacy mscomct2.ocx

    Once The Control is registered, it can be added to the Control Toolbox available in the VBA area of Excel:

    AdditionalControls.jpg

    Select the date picker control from the list of available Active-X controls:

    NewDatePickerControlSelection.jpg

    Once it is selected, it can be used from the toolbox:

    NewDatePickerToolboxIcon.jpg

    Download link for mscomct2.ocx
    https://www.ocxme.com/files/mscomct2_ocx
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    239

    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

  6. #6
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    239
    I sent tge instructions to one user
    Attached Images Attached Images

  7. #7
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    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 Attached Files

  8. #8
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Date Picker not available

    For this,try, when your Windows is 64bit.
    I sent tge instructions to one user
    Install MSCOMCT2.OCX in the C:\Windows\SysWoW64 folder.
    and register with %systemroot%\SysWoW64\regvr32.exe mscomct2.ocx
    If the office version is 64bit, you can't use the datepicker at all.
    Office 64bit and windows 64 bit are 2 diffenrent things.

  9. #9
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit on Win7
    Posts
    956

    Re: Date Picker not available

    @Mahmoudelnemr; Some ActiveX controls such as Datepicker or Listview controls create problems in VBA codes, if not installed on the PC.

    I would advise you to create your own simple "Calender" control by using standart ActiveX objects (Userform, Label, CommandButton, etc.) and include it in your project. Doing so, your project will work on every PC whether it has 32 or 64 Bit Office and/or OS.

    .

  10. #10
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,406

    Re: Date Picker not available

    is the month viewer available to you in the vba toolbox ????

  11. #11
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    239

    Re: Date Picker not available

    i need calender and time picker, i gave up , gonna use normal textbox

  12. #12
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,406

    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).
    torachan.
    Attached Files Attached Files

  13. #13
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    239

    Re: Date Picker not available

    Quote Originally Posted by torachan View Post
    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).
    torachan.
    Thanks, torachan.
    I removed the DTpicker, still users have error ""could not load some objects because they are not available on this machine""

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,801

    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!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  15. #15
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    2010
    Posts
    239

    Re: Date Picker not available

    Yes, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Setting date picker date and having 2 columns to each date for excel calendar
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2017, 11:13 PM
  2. [SOLVED] Date picker-Need it to default to today's date. Also getting error but it seems to work.
    By aliciaward1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2017, 12:56 PM
  3. Replies: 5
    Last Post: 04-06-2016, 06:58 AM
  4. Date picker used to populate text box. Date changes back to original value on opening.
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2016, 09:42 AM
  5. [SOLVED] file-picker thinks it is a folder-picker if the folder picker runs first?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2016, 01:14 PM
  6. Replies: 0
    Last Post: 08-01-2015, 12:29 AM
  7. Replies: 7
    Last Post: 12-08-2013, 06:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1