Hello,
I am using excel userform to maintain client receivable.
I created report which will be in Listbox. When I use macro it search for
the client and show report in Listbox.
But my list box does not showing more than 10 column.
I cannot use column heads = true and "Rowsource". like this method.
B'cause that doesn't works for my macro. Any way I need
to add more than 10 column. Please I find difficult.
Can anyone please help me.
charles
Last edited by ebin charles; 06-27-2011 at 03:00 AM.
Hello ebin charles,
A VBA ListBox will not display more than 10 columns of data unless you link the ListBox to Range using the "RowSource" property. Can you explain more about why you can not use this method in your macro?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Because when I apply this method, all the data which comes under the RowSource will load automatically when userform initialize. But I create report based on some criteria.Originally Posted by Leith Ross
Criteria like my Client and their Project/Service/Agewise and so on. Is there any other possible way to select report with criteria under above method.
please help me.
charles
Hi charles
Filter the data then populate the ListBox.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Dose not matter of filter, but the no of column will be the same.
By filtering you can reduce no of rows but not column.
Charles
Hi Charles
Tis trueI think Mr Ross is correct. Please explain more explicitly what you're trying to do.By filtering you can reduce no of rows but not column.
It's ok but I do not much idea in vba.
I am just learning.
If someone helps me it'll be well and good.
or give idea to do such.
charles
Hello Charles,
The only other solution I can offer you is to use a ListView object instead of the ListBox. This will overcome the columns limitation and also provide you with extra features not available with with a ListBox. I have attached a sample workbook so you can see what it looks like.
Thank you so much. But can I get total for certain column.
you have given me example file, in that can I get total for amount column?
Much better for me If it is ok,
please help me.
charles
And I have more than four macro function in "Listbox", can I apply same in "ListView"?
I got success for first macro to get the total for column by this code:
By the same time when I click the list it need to load in textbox for edit.
Please Login or Register to view this content.
Is it possible?
charles
Last edited by ebin charles; 06-26-2011 at 12:30 AM.
Hello Charles,
I will work on converting the ListBox code to work with the ListView. Yes, a total row can be added in.
Thank you so much.
I can learn much of vba from excel forum. Thank you.
Charles
If you populate the listbox with a variant array the column limit can be over-ridden.
http://www.vbaexpress.com/forum/arch...p/t-15038.html
Your issue then becomes creating a variant array from the filtered data.
Thank you very much.
Then please show me to have filtering with variant array.
so that I modify my own code.
charles
This should get you started.
Please Login or Register to view this content.
Thank you so much.
As Leith Ross said, Is it possible in ListView.?
Charles
In your code how to avoid column no 1.
Because I already choose name in top Box1.
In previous code I used, I can choose column from sheet to display in listbox . (B1, C1, D1, E1, ---, G1)
Is there option to choose column in your code?
Charles
Last edited by ebin charles; 06-26-2011 at 12:15 PM.
try here
Please Login or Register to view this content.
Last edited by john55; 06-26-2011 at 12:37 PM.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Hello Charles,
I was out and about with my family today. Here is the modified workbook. It has the macro and the ListView object added to it. The Grand Total line appears below the last amount in bold text.
Thank you so much.
But I find difficult in filtering Client & project wise.
Is it working for you?
charles
Hello Charles,
If by "Client" you mean the "List" column, I have no problems with the data being filtered or not filtered. What problem are you experiencing?
I need to filter by Client wise as "Box1" value,
at the same time Project wise as "Box2" value.
I need "Saudi Arabian Saipem" clietn with "Qassim" project entry.
Is it possible?
Charles
Hello Charles,
I made the changes to the filtering. Have a look at this workbook and let me know what you think.
Thank you SO MUCH.
What I need to say?. NO Words to say.
You might have solved more tougher than this code.
But for me this solution meant, you are really great.Genius.
When I select a entry in List view, will it display in below textboxs so that I can edit
the entry and save back.
Charles
Hello Charles,
I meant to ask you which Text Boxes need to be filled in. Can you show me a list of the Text Boxes to fill in?
I have textboxs just below "ListView". I need to load the certain details in below TextBoxs when I click ListView.
So that I can edit and save back.
Charles
Hello Charles,
I used the Text Boxes that were listed in the ListBox_Click event. The only problem I had was I could not find a PO number listed anywhere. That Text Box is blank. Check this workbook and let me know what needs to be updated.
Honorable Leith Ross,
I bow my head before vba Legend, LEITH ROSS.
You have reached the highest.
There's lots to say....
Than you MASTER. Have a good day.
Regards
Charles
i have listdox and use add.item method why i cannot add.item UserForm1.ListBox1.List(r - 1, 10) = UserForm1.Label49.Caption
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks