Dear Forum Members
RomperStomper has just helped me by solving a problem "RemoveDuplicates in VBA" which seemed to revolve round a parameter array used in the RemoveDuplicate coding.
On the same workbook I now have a problem where I cannot show a userform because of the following error message
"Could not set list property. Invalid property array index".
The code involved is
Private Sub UserForm_Initialize()
With EntryForm
.ListBox1.List = Sheets("ALL_UNCHECKED").Range("A11").CurrentRegion.Value
'.ListBox1.List = Sheets("ALL_UNCHECKED").Range("A11:J16")
.TextBox12.Value = Format(Now, "dd/mm/yyyy")
.TextBox13.Value = Sheets("UTILITIES").Range("A10").Value
End With
flag = 0
End Sub
Neither the third line or the rem'd line work, and I am surprised I have used very similar code before. Is it possible that my two problems are connected?
I have attached the full workbook.
OpenForm just enables secondform and it is the button Enter Orders which starts the problem.
The sub userForm_initialise() is in the code of EntryForm
Bookmarks