DEBLACKJACKAL
Programmer
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
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