I am missing something here and I don't know what.

Hi,

I'd appreciate you patience here as I'm 40 and trying to teach myself how to code. Full disclosure I'm following a YouTube guide and despite having the same code I'm getting different results.

I have two main problems here:

1. When I edit a record it will create a new line rather than editing the existing line. When I click save on an existing record I'd like that to change rather than a new one being created. Each "Load ID" should be unique. I'll work on a filter that stops the duplication of Load ID's later.

2. The search function will not play ball. Either the button is greyed out or nothing happens when I click with a search term. If no search term is entered it will show the msgBox I've programmed.

This line of code is causing no end of issues. I thought I had if fixed in the debugger but now its stopping me deleting rows.

iRow = Application.WorksheetFunction.Match(Me.lstDatabase.ListIndex(Me, lstDatabase.ListIndex, 0), _
ThisWorkbook.Sheets("Database").Range("A:A"), 0)

Before it was showing a Compile error: Expected:expression


I've attached the sheet. Rather than just fixing it I'd far rather know where I'm going wrong and how to fix it.

Thanks

Ad.1 In the Submit procedure, delete the second occurrence of the code line:

Please Login or Register  to view this content.

Artik