Results 1 to 3 of 3

Formatting data in a listbox

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2011
    Location
    Copenhagen, DK
    MS-Off Ver
    Excel 2007
    Posts
    30

    Formatting data in a listbox

    Hi y'all,

    I am populating a listbox with 5 columns using this code:
    Private Sub ListBox1_GotFocus()
    Dim vList As Variant
    
    With ThisWorkbook.Sheets("Handelsbanken")
      vList = .Range("b3", .Range("b3").End(xlDown).End(xlToRight))
    End With
    
    Me.ListBox1.List = vList
    End Sub
    It works fine, however the formatting is ugly. I would like column 1 & 5 to be a date DD-MM-YYYY and column 2-4 to be number with commastyle (x.xxx,xx).

    Is this possible?

    Thanks for your time!!

    Kind regards
    KRAND
    Last edited by KRAND; 05-12-2011 at 04:24 AM.

Thread Information

Users Browsing this Thread

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

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