I'm trying to add items to the second column of a listbox using vlookup but i keep getting a run-time error 380 "cound not set the List property. Invalid property value.
I can't figure out what is going on. the column count is set to 2 on the listbox.
it fails on this line
Please Login or Register to view this content.
any help would be greatPlease Login or Register to view this content.
Any chance you could upload a sample workbook?
Click on GO ADVANCED, scroll down and click Manage Attachments.
If posting code please use code tags, see here.
Here you go
Hi,
You may want to take a look at the first line of your Userform_Initialize routine.
Don
Please remember to mark your thread 'Solved' when appropriate.
I switch it back to 2 when the customer class module is run
Oh- it is because you assign a 1D array to the list. Although the column count remains 2 the second column is inaccessible as best I can tell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks