Results 1 to 10 of 10

Date Picker / Calendar for Combobox

Threaded View

  1. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Date Picker / Calendar for Combobox

    I have not looked at your code. I have a 'DatePicker' done entirely in VBA in the attached file adapted from another person's original code. The other person did all the HEAVY lifting.

    You should be able to adapt what I've done for your needs. Click on the 'Test Calendar Form Using UserForm1' button in Sheet 'Main' to see the 'DatePicker' in action with a very simple UserForm.

    The function you want to use is 'LjmGetDateUsingCalendarForm()' in module 'ModLJMPicker'. It explains what resources are needed to port the 'DatePicker' to your application.

    Good luck.

    Edit: Added for Lewis - September 2, 2015:
    The file associated with this post can still be used, but is valid for US dates ONLY.
    Attached Files Attached Files
    Last edited by FDibbins; 09-02-2015 at 08:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to add a date picker / Calendar from clicking a cell
    By RichardJSigKits in forum Excel General
    Replies: 6
    Last Post: 02-09-2013, 12:52 PM
  2. [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
  3. Replies: 3
    Last Post: 09-06-2010, 02:31 PM
  4. [SOLVED] mscmctl2.ocx ... calendar and date picker sometimes not available
    By thisIsNotMe@hotmail.com.nospam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2005, 08:05 AM
  5. [SOLVED] Creating a calendar in a cell for a date-picker
    By MarkieE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2005, 09: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