HOW TO QUERY AND EMPTY A MULTI COLUMN LIST BOX AND PRINT THE FILTERED RESULTS OF A LIST BOX

[DEBLACKJACKAL]

Hello

Sincere regards to you all

Sincere regards to you all. I am a fresher in VBA coding but very much in love with the challenges involved in coming up with a presentable Excel VBA application.

Am trying to construct a Stock and Sales Management System for my business using Excel VBA code and in this regard am seeking for enlightened assistance in dealing with some challenges at hand. I have attached my workbook named STOCK SYSTEM 3.xlms. Please take a look at User form 7. This is a basic Sales Search Form through which I intend to search for individual item receipts, view individual cashier sales based on a start and end date, individual item sales and specific transaction sales whether Retail or Wholesale. For starters the form seems to partially work but despite ceaseless coding changes I am totally confused in figuring out why when I try to filter by start and end date of a specific cashier it is displaying an entire unfiltered list. Second is the clearing or refreshing the battery of text boxes and the List box (List box 1) itself after conducting a search using Command button 6 (Clear Results). It seems to work the first time clearing all contents but also the headers and after that all attempts to clear the text boxes and list box are met with errors. Why is this so? No three can anyone please guide me in constructing a smooth synchronized code that will print (Command button 7) the filtered results in a List box
Will appreciate any available and willing assistance provided.

Cheers
DEBLACKJACKAL

 

[dhookom]

Hi DEBLACKJACKAL and welcome to Tek-Tips.

I hate to say this but are you sure Excel is the right tool to create a system like this? I assume you have looked at off-the-shelf solutions that might cost more but save dollars in the long term? Being an Access developer I would think a database would be better.

If you don't get useful replies, you might try to break your questions into three separate threads.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[DEBLACKJACKAL]

Hello Dhookom

My hopes that you are fine.

Do appreciate your recommendations.Am based in Kenya. Did do a research of the off the shelf solutions and they are indeed expensive. Further the available solutions require an annual renewal subscription fee. Most of the financial data at business is Excel based that's why I have opted for Excel VBA.

Cheers and Regards from this end of the global map.

DEBLACKJACKAL

 

[dhookom]

If that is the case then I would suggest you break down your question into smaller bites with adequate information. I am far from an Excel expert and can't afford the time to figure out how to answer your issues. I hope someone else can provide solutions.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[DEBLACKJACKAL]

Do appreciate your views. Thanks all the same.

 

[mintjulep]

Many of us are unwilling to download random files, especially macro enabled ones.

Your requirements all seem achievable with Pivot Tables. No VBA required.