+ Reply to Thread
Results 1 to 4 of 4

Date Dropdown/Pop-up without Design Mode

  1. #1
    Registered User
    Join Date
    12-03-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    9

    Date Dropdown/Pop-up without Design Mode

    Hello,

    I'm trying to insert a drop-down/pop-up calendar in the cells of a column of my Excel.

    My first idea was to activate the Design mode and then use the "Microsoft Date and Time Picker Control 6.0". But that is not working properly on my boss's computer nor on mine.


    Is there any other way I can implement it? Maybe with Macro or Formulas?


    Thank you!


    Lucas

  2. #2
    Banned User!
    Join Date
    01-26-2019
    Location
    United States
    MS-Off Ver
    2010
    Posts
    32

    Re: Date Dropdown/Pop-up without Design Mode

    Hello,

    I found this link to install the Date and Time Picker. It wasn't on my system but now it is following these instructions:

    https://www.ablebits.com/office-addi...er-date-picker

    I hope this is what you want.

    Good luck,
    B

  3. #3
    Registered User
    Join Date
    12-03-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    9

    Re: Date Dropdown/Pop-up without Design Mode

    Hello Billy,

    that sadly wouldn't work, since other people will be using the excel as well - and they all would have to install it in order to see and use it, which is unviable.

    Would you have any other suggestion?

    Thanks!

  4. #4
    Banned User!
    Join Date
    01-26-2019
    Location
    United States
    MS-Off Ver
    2010
    Posts
    32

    Re: Date Dropdown/Pop-up without Design Mode

    Maybe use a calendar template like the one Vertex42 has?

+ 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. Vba design mode
    By courtneyhogan in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-18-2017, 11:32 AM
  2. can't get out of design mode
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2015, 11:12 AM
  3. Design mode
    By endjy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-20-2015, 08:44 PM
  4. Replies: 4
    Last Post: 06-06-2013, 10:21 AM
  5. Design Mode
    By juliamh4 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2007, 02:13 PM
  6. [SOLVED] Hyperlinks Inserted in Design Mode inactive once Exited Design Mod
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 01:06 PM
  7. Replies: 0
    Last Post: 01-07-2005, 04:06 PM

Tags for this Thread

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