+ Reply to Thread
Results 1 to 3 of 3

Display start date to end date in a listbox

  1. #1
    Registered User
    Join Date
    10-20-2014
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    11

    Display start date to end date in a listbox

    Hi Guys,

    Need your help.
    I am trying to display the start date and end date on a list box having this format.
    MM/DD/YY (start date) – MM/DD/YY (end date)

    I have attached the screenshot of the userform:
    Capture.JPG


    Below is the code I have created, however, result is showing wrong format on the end date
    I have tried to format the D as date as well, however it is having errors.

    MM/DD/YY (start date) – MM/DD/YYYY (end date)


    Please Login or Register  to view this content.

    Appreciate the big help guys
    Thanks in advance!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Display start date to end date in a listbox

    FYI, a picture of a form is not worth a lot.

    Try:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    10-20-2014
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    11

    Re: Display start date to end date in a listbox

    Hi romperstomper,

    Will take note of that info about picture
    Thank you so much!!! the code works!!!

+ 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. Counting if data falls on date between Start Date, End Date or Possible End Date
    By JessHasQuestions in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-26-2014, 08:01 AM
  2. Replies: 2
    Last Post: 04-23-2014, 09:07 AM
  3. [SOLVED] Display all data within Start and end date
    By spangpang in forum Excel General
    Replies: 6
    Last Post: 04-08-2013, 09:47 AM
  4. Replies: 1
    Last Post: 10-02-2012, 02:42 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