+ Reply to Thread
Results 1 to 2 of 2

Why is there a run time error and how do I fix it? Could not get the list property invalid

  1. #1
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    243

    Why is there a run time error and how do I fix it? Could not get the list property invalid

    hello every one when I open up the workbook and try to use the dropdown list in Column3 i get a MVB error message

    Run time Error
    Could not get the list property.

    when I debug it goes to this line of code.

    Controls("TextBox" & i).Text = Me.ComboBox1.List(sc, i - 1)

    Now it was working when I had only 18 text boxes, but I had to add 200 more and then I got this.

    What did I do wrong and how do I fix it.

    Please let me know, and thank you all
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    243

    Re: Why is there a run time error and how do I fix it? Could not get the list property inv

    Thank you all On my parts Data tab I didnt have enough columns, I stopped at 200 but had 210 text boxes, If you add or subtract the additional columns, the number of text boxes in the vba must match the number of columns.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Error 381Could not set the List property. Invalid property array index
    By desonny in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2020, 08:33 AM
  2. Replies: 5
    Last Post: 06-02-2020, 04:56 PM
  3. runtimer error 380, could not set the list the list property, Invalid property type
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2015, 12:19 PM
  4. Runtime error 381: Could not set the list property.Invalid property array index
    By rohith4prithvi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2014, 10:24 PM
  5. Run-time Error '380': Could not set the RowSource property. Invalid property value
    By Rem0ram in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2013, 03:57 PM
  6. [SOLVED] Excel run-time error '381': Could not set the List property. Invalid property array index
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-20-2012, 12:48 PM
  7. Replies: 2
    Last Post: 06-11-2012, 03:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1