I am building a userform with some 50 textboxes, most on a multipage control spread over 5 pages. Most of these are prefilled with ‘ 0.00 ‘ and are the ones I am focusing on in this post. On any given transaction perhaps only 5 of these textboxes will be altered by the user. As a visual aid to the user, I am using a listbox with 2 columns to post the label and contents of these textboxes This allows the user to see exactly where and by what amount they changed individual entries. As it stands, all of the textboxes are listed including the many that haven’t been altered. Having a long list of items that are 0.00 is more of a hindrance than an aid. I am looking for a method to directly filter out the 0.00 entries, listing only the contents of those textboxes that have been changed.
I have played around with writing a temporary list to a worksheet, sorting and filtering out the unwanted information and posting the remainder to the listbox but that seems cumbersome… Is there a better way?
Thanks
Scott
Bookmarks