Apr 13 2024 12:01 AM
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.