Results 1 to 3 of 3

How To make column 3 a date format in listbox.

Threaded View

  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.


    With ListBox1
                    
                       .AddItem ""
                       .List(.ListCount - 1, 1) = Cells(r, 1)
                       .List(.ListCount - 1, 2) = Cells(r, 2)
                       
                       .List(.ListCount - 1, 3) = Cells(r, 3)
                      
                       .List(.ListCount - 1, 4) = Cells(r, 4)
                       .List(.ListCount - 1, 5) = Cells(r, 5)
                       .List(.ListCount - 1, 6) = Cells(r, 6)
                       .List(.ListCount - 1, 7) = Cells(r, 7)
                   End With
    Last edited by Fotis1991; 09-12-2013 at 06:34 AM. Reason: Mod request: Pls use code tags around your code. Yhanks.

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