Hello
Regards to all. Still a fresher but seeking some enlightened help and direction on how to clear a Bound List box in an excel user form. Am trying to creat a Stock and Sales Management System using in Excel using VBA code. Initially I had no idea how challenging this task would turn out to be. Currently about 65 percent of the work is done but still a lot to get done. I have attached my workbook named STOCK SYSTEM 3.xlms. Focus on Userform7. This is a Sales Search Form through which the user can 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. The form partially works but my challenge is clearing or refreshing the battery of textboxes and the List box (LISTBOX1) after a search is conducted that is on Command button 6 (CLEAR DATA RESULTS). Whenever I click at this button it seems to work the first time but after that I am getting infuriating errors on Listbbox1.Clear line of code. Can anyone please guide inputting a smoothing working coding that will fulfill this task
Will appreciate any available help provided.
Regards
DEBLACKJACKAL
Bookmarks