ListView Mod!

Originally Posted by 6StringJazzer

This isn't hard, but your explanation has a few holes. What data from the sheet do you want load into the ListBox? If it's more than one column, what columns do you want displayed in the ListBox?

My Mistake :-(
I would like to display the data from sheet 1 columns A,B,C,D rows 2-500 for each column it is easy to just display this data but I want to make sure that it still works as it is now so that I can load data from 1 listbox to another ect.
Thank You
Dan

Change the GetInfoFromSomewhere routine to:

Please Login or Register  to view this content.

and then adapt the code in the form as follows:

Please Login or Register  to view this content.

Thanks it works well in the same workbook but it doesn't work in my other workbook
this is the error:
User defined type not defined

with this line of code:

Please Login or Register  to view this content.

This is a whole code:

Please Login or Register  to view this content.

Any idea why this has happened when I have changed the workbooks? and how to fix it?
Thanks

Add a reference to the Listview control in the 2nd workbook... (Menu: Tools/References)

Thanks
What is the reference name as I can't find it???

You need to add the listview into the controls toolbox I suspect

Grate it works
THANK YOU!!! :-)
One more question....
Previously I have used the standard listbox which was populated with data from sheet 1 but only if the WORD in column Y was "OPEN" THIS MEAN THAT THE REPORT IS STILL OPEN.

Would it be possible to do with my new ListView??

Here is the code:

Please Login or Register  to view this content.

Originally Posted by Kyle123

You need to add the listview into the controls toolbox I suspect

Hi Kyle123
Would you be so kind and take a look at my code above please?

Originally Posted by Kyle123

Like this, as an example in your sample workbook, change some of the Person Names to OPEN

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Kyle123 :-)
Thank you so much for replaying !
I think it will work but curently I am getting this error: Invalid Property Value with this line of code: avar.SubItems(ii) = CompanyInfo(i)(ii)
Any Idea what may be wrong.
Thank Yoy again!
Dan

Dunno, check the code you're actually using as I made an edit after the post.

Here's a working example

Originally Posted by Kyle123

Dunno, check the code you're actually using as I made an edit after the post.

Here's a working example

Forgot to mention that this was a test workbook and on the original workbook the OPEN is in column Y and I cannot change it due to layout.
It does work with the sample book so it could be a question of layout of my workbook??? I'ts still Sheet 1 but has lot more columns with data..... 35 being more specific

AS per the comments in my code, you need to amend the column that you are checking for the word in. Without a more accurate mock-up I'm struggling to help any further really, just set break points in your code and inspect the locals to try and suss it out.

Originally Posted by Kyle123

AS per the comments in my code, you need to amend the column that you are checking for the word in. Without a more accurate mock-up I'm struggling to help any further really, just set break points in your code and inspect the locals to try and suss it out.

Ok Let me upload amy workbook then :-)

Originally Posted by Kyle123

AS per the comments in my code, you need to amend the column that you are checking for the word in. Without a more accurate mock-up I'm struggling to help any further really, just set break points in your code and inspect the locals to try and suss it out.

It's not best looking workbook but this is exacty how I have it in my orginal book the one I was getting an error.
So what I would like to see is 4 columns displayed when text in column Y=OPEN
ColumnA
ColumnB
ColumnN
ColumnR
Column Y doesn't need display status but if it can be done then it's even better....

Thanks You I really mean it!

Off the bat you don't have enough headers, you've only got 4, you need one for each column. Your formatting is also a bit of a mess and so needs allowing for, the below isn't as dynamic as I'd like, but works:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Just re-read that you only want certain columns, try this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by Kyle123

Just re-read that you only want certain columns, try this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kyle you're are amazing!!
Everything works as it should apart from I cannot copy selected row into second listbox...
and also how do I limit the amount of column displayed in listview?
Thanks you so much for your help.

That code does limit the number of columns? There should only be 5?

The listbox works fine for me, what issue are you having?

Kyle I can't thank you enugh!!
It's all working now
Tahnk you for your help :-)

No probs