Clearing a listbox

[DEBLACKJACKAL]

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

[Akuini]

It could be the problem:

Please Login or Register  to view this content.

Please check this:
http://www.snb-vba.eu/VBA_Fill_combobox_listbox_en.html
In the article:
"If you use 'rowsource' you make a direct link to a certain range in a worksheet.
Combined with the combobox it can cause Excel to blackout, because any change in the combobox will be transferred directly to the 'source'.
Excel has proven not to be able to do this correctly.
Besides: the changing of the source at every change in the combobox slows down your code.
You should reduce the reading/writing from/to a workbook in your code as much as possible. "

so replace with this:

Please Login or Register  to view this content.