+ Reply to Thread
Results 1 to 4 of 4

Need to Install Date Picker in Excel VBA - User Form, But not available in control setting

  1. #1
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    Need to Install Date Picker in Excel VBA - User Form, But not available in control setting

    Dear Forum Members,

    I am developing a user form for reporting system, in which i would like to create a date field with the assistance of date picker. But date picker is not available in my excel file control settings. The following are my system and excel editions / versions.

    System: Windows 10, 64 bit operating system, x64-based processor

    Ms-Excel - Microsoft Office Standard 2013 (15.0.5031.1000)32-bit

    Kindly help and guide me to install date picker and do the needful.

    Regards

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Need to Install Date Picker in Excel VBA - User Form, But not available in control set


    Hi,

    many ActiveX like the date picker do not exist for Excel 64 bit version,
    the reason why Microsoft itself advises to install its 32 bit version.

    As it seems you have a 32 bit version, try from VBE on the UserForm tools to see in the additional control list if it appears …
    Last edited by Marc L; 05-15-2018 at 09:30 AM.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,529

    Re: Need to Install Date Picker in Excel VBA - User Form, But not available in control set

    Transfer code and relevant userforms to your workbook.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    Re: Need to Install Date Picker in Excel VBA - User Form, But not available in control set

    Dear Mr. Jolivanes

    Thanks a lot for your guidance. But I have got the inbuild option through registering command prompt.

    Regards

+ 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. EXcel User Form Date Picker 2016
    By jchillet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2017, 06:59 AM
  2. Add Date to User Form Without Access to Add Date Picker Control
    By kaleonard08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2016, 12:06 PM
  3. Can't install/use Microsoft Date Picker in VBA for Excel User Form
    By GeminiG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2016, 10:20 AM
  4. How to install date picker in UserForm: not seeing Monthview control in References
    By Pimp_mentality in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2015, 04:38 PM
  5. [SOLVED] Calendar Option in the user form - date picker
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2012, 02:46 AM
  6. Date Picker from user form
    By Denzil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-07-2008, 04:28 AM
  7. Date Time Picker in User Form
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2006, 01:07 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