I have attached sample workbooks. Both workbooks should be open in memory.
Workbook1 contains the main VBA code.
Workbook2 contains a UserForm and VBA code to show the form.
The bit of code where I'm encountering the error:
Code: Select all
' Add an item to the ListView control
Dim newItem As Object
Set newItem = targetListView.ListItems.Add(1, , "File") 'Errors: Property is write-only
newItem.SubItems(1) = "05/26/2016"
newItem.SubItems(2) = "Some Description"
newItem.SubItems(3) = "100.00"