Seeking introductory help with ListView in UserForm - to dispaly data from Excel worksheet.

I need to develop catalog reports for data in excel worksheets. I have a ListView control in the userform and activeX tool boxes (thanks to Martin Liss).

I want to keep speardsheets hidden from the user, so hope to display ListView on a userForm; is that OK?

One need is to list Icon images, so displaying the Icon appearance in the catalog would be great - can list view display customised images?  [The Icons are simple, can be .bmp, .gif, .jpeg, ico.. .]

I spent a few hours searching for 'starter' coding information on ListView, without finding a comprehensive start point for vba.

I do write dynamic UserForms of some complexity, but using basic set of Form controls.  
Can you point me to sites that introduce coding for ListView (data from speadsheets especially).

I hope you can help (sources of specimen code would be very much appreciated).

Thanks!
Kelvin
Kelvin4Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
I may be able to help with the listview but first what do you mean exactly when you say "[you] want to keep speardsheets hidden from the user"?
0
Martin LissOlder than dirtCommented:
Take a look at the attachment in my last post in this thread. Note: The code hides the column headers and substitutes labels and you may not want to do either.
0
Kelvin4Author Commented:
Thank you again.
The attachment gives me a good starting point.

I use Excel to control Visio, which constructs data-driven visio drawings. The OUTPUT of the exercise are the drawings. So most of my excel sheets are hidden by closing down much of the Excel window below the fluent ribbon (which itself is largely replaced/customised), and moving the worksheets up out of sight  (until one is needed  - when all returns to a more normal config.)

Do you think ListView will display graphics from the likes of my small icon files? If not, perhaps that requirement would be better met by showing the file images in a spreadsheet?

Kelvin
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Roy CoxGroup Finance ManagerCommented:
Here's a workbook that I used to experiment with the ListView control

Here's a recent file to disguise Excel

I think you want the ImageView control. I used to have a example by Colo but I can't find it and his sites have disappeared.

Here's a link to Jan Karel Pieterse's  MSForms (All VBA) Treeview, this should be well worth studying
ListView-Example-3-.xlsm
DEMO-ToggleRibbon.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
So most of my excel sheets are hidden by closing down much of the Excel window below the fluent ribbon (which itself is largely replaced/customised), and moving the worksheets up out of sight  (until one is needed
Couldn't you hide rows and/or columns and then protect the worksheet so its structure can't be changed?
0
Kelvin4Author Commented:
Martin & Roy:
Thanks for giving me good starting points, so quickly.

Kelvin
0
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest youincluding these two new ones.
An Experts Exchange Shortcut for the Truly Lazy (for Apple OS X)
A Guide to Writing Understandable and Maintainable VBA Code
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
0
Roy CoxGroup Finance ManagerCommented:
Glad to help. let us know how you get on
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.