Not the answer you're looking for? Invalid property value.] up vote 1 down vote favorite I’ve reviewed 10s of reported problems with similar error code but none match my scenario.. I'm too cold, turn up the temperature What is the proper usage of "identically zero"? However it works on mine? Source
Share Share this post on Digg Del.icio.us Technorati Twitter Microsoft MVP - Excel Reply With Quote Sep 6th, 2011,08:56 AM #5 Peter Thompson Board Regular Join Date Dec 2008 Posts 262 I'm also stumped on why this error is getting thrown. Why did Sansa refuse to leave with Sandor Cleagane (Hound) during the Battle of Blackwater? Does a byte contain 8 bits, or 9?
Its the same every time. Where should a galactic capital be? You have to use 2 loops to get the values of all the cells. As it looks COM related we investigated the fm20.dll and found that if we replace the fm20.dll with an older version from another machine that hasn't had Office 2010 installed everything
Edited by juanceusse Saturday, November 09, 2013 2:28 AM Saturday, November 09, 2013 2:26 AM Reply | Quote 0 Sign in to vote juanceusse Where did you get the 20/06/2016 version? I was wondering if you could give an explanation as to how it works. Remember Me? Excel Vba Listbox More Than 10 Columns Why do manufacturers detune engines?
Here is the code where the error occurs - LastAddress = Sheets("TempList").Range("A100").End(xlUp).Address ComboBox1.List = "TempList!A2:" & LastAddress Thanks so much! I hope it can help you and feel free to follow up. This cleared up my problem of getting an error after a listbox was filled more than 99 times. http://stackoverflow.com/questions/35058954/could-not-set-the-list-property My VBA application has the same problem.
Regards, Jamie Monday, February 14, 2011 9:40 AM Reply | Quote 0 Sign in to vote Hi Jamie, I think it is the version conflict betwwen the original creation and current. Could Not Set The List Property. Invalid Property Value I have not tested it yet. Dim i As Long, count As Long. The code does not fail first time through the code.
Make sure th... 485 Invalid picture type 486 Can't print form image to this type of printer 490 Top-level or invalid menu specified as PopupMenu default 520 Can't empty Clipboard 521 http://stackoverflow.com/questions/34684217/error-381-could-not-set-the-list-property-invalid-property-array-index Recently, on machines which had had Office 2010 installed, we're seeingthe following error:"Run-time error '-2147467259 (80004005)' Could not set the List property. Could Not Set The List Property. Invalid Property Array Index We have a shared Excel file here in the company where there is a userform containing listboxes and only the users that got the new Office 2010 are having problem. Listbox More Than 10 Columns Invalid value property' I think you need to tell us what you ate doing when this happen.
Using .RowSource or using Listbox1.list =
After they search by the first column the row(s) should populate the list box so that the user can select that row and it auto fills the textboxes in the userform Friday, February 11, 2011 7:33 AM Reply | Quote 0 Sign in to vote Hi Bruce thanks for the reply. Thursday, October 06, 2011 4:44 PM Reply | Quote 0 Sign in to vote Bruce, Did Microsoft recognize this issue? have a peek here I've also created forms in a new workbook with a number of listboxes, populated themin a number of different ways, and can't replicate the error when I do that.
He's using Office 2010 Plus. Excel Vba Could Not Set The List Property Type Mismatch I am attaching a dummy workbook. Is there some way the re-register the control as a workaround?
Best Regards,Bruce Song [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark Regards, Jamie Tuesday, February 15, 2011 2:45 PM Reply | Quote 0 Sign in to vote Hi Jamie, Did you mean that you didn't install any older Office application but just There are so many variables that could affect this. –Mr. Could Not Set The Value Property. Thanks everyone. –Chris2015 Jan 8 at 19:51 | show 3 more comments active oldest votes Know someone who can answer?
It also allowed me to use the Rowsource property or Listbox1.List = vArray to fill the listbox with no error, not just .AddItem. Any ideas on this? It seems most likely it is falling down on the values that it is trying to populate the listbox with as you say the GUI appears blank but the listcount property Check This Out There are usually lots of breaks between rows.
It appears that the only link is when Office 2010 has been installed on the PC (even if it has been subsequently uninstalled). Best regards, Carlos Obata Thursday, December 15, 2011 7:32 PM Reply | Quote 0 Sign in to vote Hi Carlos, Thank you for your valuable feedback. We see the same behaviour whilst using older versions of Office on the same machine.