Consulting

Results 1 to 10 of 10

Thread: Listview

  1. #1
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location

    Listview

    i have put a listview onto my userform but i cannot figure out how to set or change the headings, can anyone assist please

    Thanks

    Gibbo

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,478
    Location
    Hi Gibbo,
    I'm not clear what you mean by ListView. Can you post a copy of your form?
    Regards
    Malcolm
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  3. #3
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location
    Thanks for looking Malcolm,

    I ve attached my form, Listview is a component similar to listbox, only i prefer it if can figure out my headings problem

    Cheers

    Gibbo

  4. #4
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,478
    Location
    I'm getting an error when I try to import it.

    Line 8: Property OleObjectBlob in UserForm2 had an invalid file reference.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  5. #5
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location
    Cant seem to upload another example, its on the toolbox additional items in the vba under Microsoft listview control v6.0 if that helps

    Thanks

    Gibbo

  6. #6
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location
    Anyone?

    This is driving me nuts!!!!

  7. #7
    VBAX Mentor sheeeng's Avatar
    Joined
    May 2005
    Location
    Kuala Lumpur
    Posts
    392
    Location
    Hi, Can you upload your sample file?

  8. #8
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location
    Looks like this does the job for me, Thanks to Ivan for this

    With ListView1
    .View = lvwReport
    .MultiSelect = True
    .ColumnHeaders.Add , , "Name"
    .ColumnHeaders.Add , , "Type"
    .ColumnHeaders.Add , , "Modified"
    .ColumnHeaders.Add , , "Size (Bytes)"
    .ColumnHeaders.Add , , "Ratio"
    .ColumnHeaders.Add , , "Packed (Bytes)"
    .ColumnHeaders.Add , , "CRC"
    .ColumnHeaders.Add , , "Path"
    End With

  9. #9
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,478
    Location
    Glad its solved Gibbo. I've never used ListView, so I'd be interested in seing a finished article. Maybe you could create a KB entry out of this and any other of these additional form tools that you use.
    Regards
    Malcolm
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  10. #10
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location
    When i have it working properly, i ll submit something for you to look at

    Gibbo

Posting Permissions

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