Forum Discussion

guitar713's avatar
guitar713
Copper Contributor
Apr 12, 2024

error 380

Hello,    So the new problem I am having is ERROR 380.  This is the code I have problems with .lstDatabase.RowSource = "Sheet1!A2:L" & irow   why is this not working properly.  Thanks.  
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Apr 13, 2024

guitar713 

The error 380 typically indicates an issue related to the property or method not supported. In the context of your code, it seems like the issue might be with the .RowSource property.

The .RowSource property in Excel is used to specify the source range for a list box or combo box control on a user form. However, the format you have provided for the .RowSource property is incorrect.

Here is how you should modify your code:

.lstDatabase.RowSource = "Sheet1!A2:L" & irow

Make sure to replace "Sheet1" with the actual name of the worksheet where your data resides. Additionally, ensure that irow contains the last row number where your data ends.

For example, if your data is on Sheet1 and it ends at row 100, your code should look like this:

.lstDatabase.RowSource = "Sheet1!A2:L100"

Ensure that the range you specify covers all the rows and columns of your data that you want to display in the list box. The text was created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

Resources