+ Reply to Thread
Results 1 to 2 of 2

Trevor Eyre date picker return date to specific cell

  1. #1
    Registered User
    Join Date
    05-25-2020
    Location
    Denmark
    MS-Off Ver
    Professional Plus 2016
    Posts
    58

    Trevor Eyre date picker return date to specific cell

    Hi,

    I just heard of Trevor Eyre's date picker.
    I would like to return the date to cell A2.
    I can call the calendar but fail to return the date.


    Formula: copy to clipboard
    Please Login or Register  to view this content.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Trevor Eyre date picker return date to specific cell

    I had similar problem.
    Attached file contains my work around.
    Hopefully the code should be self-explanatory.
    Also attached my calendar which you may find useful.
    clicks in columns A & B should bring up calendar.
    torachan.
    Attached Files Attached Files

+ 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. [SOLVED] Connect Userform Text or other to VBA Date Picker (of Trevor Eyre)
    By ProfXer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-09-2020, 04:11 PM
  2. how to add date picker in excel cell to enter a date
    By roofi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2019, 10:01 AM
  3. [SOLVED] VBA with date picker applied to specific cells.
    By Keibri in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-05-2019, 03:46 PM
  4. Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  5. [SOLVED] match date name and specific shift and return date in other cell
    By godlev in forum Excel General
    Replies: 4
    Last Post: 06-30-2016, 05:41 AM
  6. Replies: 0
    Last Post: 08-01-2015, 12:29 AM
  7. [SOLVED] Using date picker for specific cell
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2015, 04:25 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