1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Date Picker Issue

Discussion in 'Business Applications' started by Triple6, Aug 22, 2018.

Thread Status:
Not open for further replies.
Advertisement
  1. Triple6

    Triple6 Moderator Thread Starter

    Joined:
    Dec 26, 2002
    Messages:
    52,935
    First Name:
    Rob
    Hopefully someone can help me with but I'm trying to use the Date and Time Picker and the text isn't displaying correctly. When I first open Excel 2016 it looks partially cut off and displays a second window in the top corner that is clear, if I scroll it then looks fine. Also when I print the sheet it also looks cut off or squished just like it initially does on screen. Any ideas how to fix this?

    upload_2018-8-22_16-41-16.png
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Honestly, no idea.
    What have to created? a Drop-Down list? When is it activated?
    I'll download the file and take a look and see what the issue could be, I may be the ActiveX you used, don't know
     
  3. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Honestly, this is not a date pickr, it just shows today's date.
    What did you use?
    What is DTPicker1 , is that your creation?
     
  4. Triple6

    Triple6 Moderator Thread Starter

    Joined:
    Dec 26, 2002
    Messages:
    52,935
    First Name:
    Rob
    No, it was already in Excel.

    I went to Developer Tools, Insert, selected More Controls from the ActiveX Controls, then scrolled down to Microsoft Date and Time Picker Control 6.0.

    Is there an alternate way to get a date selection?
     
  5. Triple6

    Triple6 Moderator Thread Starter

    Joined:
    Dec 26, 2002
    Messages:
    52,935
    First Name:
    Rob
    So I just realized that it said "Microsoft Date and Time Picker Control 6.0 (SP4) so I updated the MSCOMCT2.OCX to get it to "Microsoft Date and Time Picker Control 6.0(SP6)" and now I cannot choose the date either and it only shows the current date.

    Is there a another way to bring up a calendar for the user to choose that works in Excel?
     
  6. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    I wrote my own calendar tool and that means you will need a macro-embedded file.
    There is are quite a number of code snippets.
    I personally do not like the ocx controls since they limit you when distributing the file.
     
  7. Triple6

    Triple6 Moderator Thread Starter

    Joined:
    Dec 26, 2002
    Messages:
    52,935
    First Name:
    Rob
    Okay, I guess I'll look for an alternative.
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1214830

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice