+ Reply to Thread
Results 1 to 3 of 3

How To make column 3 a date format in listbox.

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    3

    How To make column 3 a date format in listbox.

    how can i make the result that come out in column 3 a uk date format. it come out as a us date format as the minute.


    Please Login or Register  to view this content.
    Last edited by Fotis1991; 09-12-2013 at 06:34 AM. Reason: Mod request: Pls use code tags around your code. Yhanks.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644
    It's not clear from your code which column you want as a date.

    Usually in a listbox the 3rd column would have an index of 2.

    However, you are putting "" in the 1st column of the listbox.

    So the 3rd visibly populated column is the 4th column in the listbox, which has an index of 3.

    Anyway, try this.
    Please Login or Register  to view this content.
    Last edited by Norie; 09-12-2013 at 08:30 AM.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-06-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How To make column 3 a date format in listbox.

    That worked perfect, thank you so much. simple but not for me.

+ 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. Change the date field in ListBox in (mm-dd-yy) for another format (dd-mm-yyy)
    By Francisco Sousa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 10:58 AM
  2. Chnage format of Date in Listbox
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2012, 10:24 AM
  3. Listbox Column Format
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2010, 10:06 PM
  4. Format date in ListBox on Userform
    By LiamPotter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2009, 09:08 AM
  5. ListBox date format
    By brainfreez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2008, 05:29 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