Home Creators Posts Import Register Favorites Logout

Downloads

Content

In this week’s Feature, Fix, or Focus, we take last week’s Sort ListBox Data training.

Here's the list of updates I made for this training:

· Use ListView feature for more flexibility  requested by rods6405

· Right Justify Amount Column requested by rond9222, Debbie Fairbanks

· Filter Data requested by Debbie Fairban

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

Frick

The buttons are not working for me. For example; selecting the Show List View Form and selecting Populate List View the macro breaks at "Sub PopulateListView()". In the toolbox I did check that the ListView was added.

Excel For Freelancers

Hi Frick, thanks for your comment. This often means there is an issue with initializing the form. Make sure you don't have any missing libraries in the VBA Editor Tools > References. Please step through the macro Private Sub UserForm_Initialize using F8 to see where your code might break

Frick

The VBA Editor Tools add-ins are the Analysis ToolPak and the Analysis ToolPak-VBA. In my toolBox I added the MS ListView Control, ver 6.0. As mentioned earlier, the code for ShowListViewForm() and stepping through the code breaks @ Sub PopulateListView(). Thus, it will not populate the form. I am using the desktop version of Excel 2308 build 16.

Excel For Freelancers

HI Frick, it would be difficult to tell unless we saw all the conditions. Can you please share screenshots in our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel Please make sure to share the images and details so we can better help you