Combo Box - Saving Customers

I currently have a combo box which enables me to create a new customer and save their details to a sheet called ClientTable. I can also press the drop down arrow of this combo box to retrieve an existing customer and their details from the same ClientTable sheet.

My problem is that when I select an existing customer and ammed any of their details - the new information is not being saved. Hence I cannot update an existing enrty once it is created.

how I can adjust the script below to enhance its functionality so customer details can be updated.

Code in the module



Public Sub SaveNewClient()
Dim NewRow As Long, IDNum As Long
If ClientTable Is Nothing Then
Set ClientTable = Sheets("ClientTable").CurrentRegion
End If
NewRow = ClientTable.Rows.Count + 1
If ClientTable.Rows.Count = 1 Then
IDNum = 0
Else
IDNum = NewRow - 2
End If
With Sheets("ClientTable")