VBA Runtime error 70. Could not set the list property

**Sintek** · 10-03-2016, 03:10 AM

Hi All

I am getting an error with the following line of code....Can anyone assist. First time I'm working with a ListBox in this manner. I have uploaded my workbook. What I'm also trying to achieve is edit the listbox and then update workbook.

Private Sub CommandButton1_Click()
With ListBox1
.List(ListBox1.ListIndex, 3) = TextBox1.Value
.List(ListBox1.ListIndex, 4) = TextBox2.Value
End With
End Sub

**xlnitwit** · 10-03-2016, 03:42 AM

Hi again,

You can not assign an array to a listbox that has its Rowsource property set. You might alter your Initialize routine thus

Private Sub UserForm_Initialize()
    ListBox1.List = Sheets("Stock Sheet").Range("A2:h83").Value
End Sub

**Sintek** · 10-03-2016, 04:08 AM

Man oh man you guys are good at this stuff.....

May I ask how I will go about updating the corresponding sheet...Would it just be a Refresh

**xlnitwit** · 10-03-2016, 04:10 AM

If you change data on the sheet, all you need do is run similar code again to reset the List property.

**Sintek** · 10-03-2016, 04:18 AM

Sorry xlnitwit

Don't think I explained myself. If once after I've updated the listbox, how would I get the updated listbox information into the Sheet

**xlnitwit** · 10-03-2016, 04:31 AM

You need only reverse the code to write the listbox array back to the sheet

Sheets("Stock Sheet").Range("A2:h83").Value = ListBox1.List

**Sintek** · 10-03-2016, 04:35 AM

Thanks....Just figured it out.

I love this site. You all rock!!!!

VBA Runtime error 70. Could not set the list property

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA Runtime error 70. Could not set the list property

Re: VBA Runtime error 70. Could not set the list property

Re: VBA Runtime error 70. Could not set the list property

Re: VBA Runtime error 70. Could not set the list property

Re: VBA Runtime error 70. Could not set the list property

Re: VBA Runtime error 70. Could not set the list property

Re: VBA Runtime error 70. Could not set the list property

Thread Information

Users Browsing this Thread

Similar Threads

Runtime Error 380 - Could not set the Property Value. Invalid Property Value

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

runtime error 1004 unable to get match property

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

List box - RunTime Error '380':Could not set the list property.invalid property value

[SOLVED] Runtime error 1004 - unable to set Visible property of Worksheet c

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

Bookmarks

Bookmarks

Posting Permissions