Results 1 to 2 of 2

Thread: sorting listbox at column ...

  1. Oct 19th, 2000, 09:07 AM #1
    Kars Lensen
    Kars Lensen is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 1999
    Location
    Ruinen, Drente, Netherlands
    Posts
    192
    Can I, and how can I sort a listbox by starting at, say column 10 ?
    Reply With Quote Reply With Quote
  2. Oct 19th, 2000, 09:39 AM #2
    ccoder
    ccoder is offline
    Frenzied Member
    Join Date
    Aug 2000
    Location
    O!
    Posts
    1,177
    Assuming you already know how to sort arrays, then just use the Mid$ function for what ever length of text you want to sort on.

    For example:

    If Mid$(ListBox1.List(subscript), 10, complen) > _
    Mid$(ListBox1.List(subscript+1), 10, complen)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width