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
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
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'
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
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'
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
Anyone?
This is driving me nuts!!!!
Hi, Can you upload your sample file?
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
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'
When i have it working properly, i ll submit something for you to look at
Gibbo