Could not set the RowSource property,invalid property value

Am designing an inventory system that will help me manage a shop business.But am stack,am trying to write a code that will display the list of purchased items and sold item referering to the excel sheet,but when i run the code,i get a message Run time error 380:Could not set the RowSource property,invalid property value


below are the codes

Please Login or Register  to view this content.

absd.jpg

kindly assist

Hakuna matata : as the name contains a space so you must add the name between quotes like you can see in cell formula …

Hi, simiyus.
To avoid such errors, instead of using the last row you should use the range of your data (without the titles). For example like this:

Please Login or Register  to view this content.

However, if you want to display the information for only rows 5 and 6 in the listBox, then you should not use the RowSource property but load that information individually via the List property.