could not get the list property invalid argument - VBA Error code

**chrismccarthy17** · 02-02-2016, 07:06 AM

What am i doing wrong here?

Please Login or Register  to view this content.

**Olly** · 02-02-2016, 07:14 AM

Which line is returning the error?

**Norie** · 02-02-2016, 07:19 AM

Where/when do you get the error?

PS Why are you calling the UserForm_Initialize sub multiple times?

If it's to (re)populate the listbox you should move the code to populate the listbox to a separate sub and call that when required rather than calling the event.

**chrismccarthy17** · 02-02-2016, 10:44 AM

It isnt stating which line is generating the error, just pops up with the error message.

I got this code from anothe site, works fine when list box is populated with cells A1:J100... I move it to another workbook and populate it with cells U2:AD1001 and I get this error?

**Norie** · 02-02-2016, 10:45 AM

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**chrismccarthy17** · 02-02-2016, 11:02 AM

right when the workbook opens, a login screen will appear;

Username: Matt Brown
Password: 1234

Thanks guys!

File is over 1mb so had to upload on another site: http://www.filedropper.com/testpagev1 Rest assured it is safe!

**chrismccarthy17** · 02-02-2016, 11:03 AM

And sorry forgot to mention, it is the mattbrownoverview userform in VBA

**Norie** · 02-02-2016, 11:04 AM

I'v downloaded the file, now what do I need to do to recreate the problem?

**chrismccarthy17** · 02-02-2016, 11:08 AM

in VBA, view the userform mattbrownoverview, when you run it you will get the error code

**Norie** · 02-02-2016, 11:15 AM

The only error I get when running that form is here,

Please Login or Register  to view this content.

and is because there is no sheet with the tab name Sheet19.

There is however a sheet with the codename Sheet19 so if I change the above to this the error is fixed.

Please Login or Register  to view this content.

Can't seem to generate any other errors when playing with the form.

**chrismccarthy17** · 02-02-2016, 11:23 AM

Legend! I knew it would be something so small. Thanks ever so much man

could not get the list property invalid argument - VBA Error code

LinkBack

Thread Tools

Rate This Thread

Display

could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Re: could not get the list property invalid argument - VBA Error code

Thread Information

Users Browsing this Thread

Similar Threads

runtimer error 380, could not set the list the list property, Invalid property type

[SOLVED] Getting compile error 'Wrong number of argument or invalid property assignment'

Runtime error 381: Could not set the list property.Invalid property array index

[SOLVED] Excel run-time error '381': Could not set the List property. Invalid property array index

Compile error As "Wrong number of argument or argument or invalid Property assignment

Error: Wrong number of argument or invalid property assignment?

Runtime Error 380 – Could not set the list property. Invalid property value

Bookmarks

Bookmarks

Posting Permissions