I'm Stuck...Userform / Command Button export to worksheet in same workbook

Please Login or Register  to view this content.

The above is my code when the command button on a userform is clicked.

The code in Green text works fine. If the value that is entered in textbox1 is not found in column A then a new row/record is created.

Problem is when I am trying to update an existing record, meaning if a value is found in Column A, it should update the referenced column in the same row of the found/matched record in column A. The problem with the code above is that if one enters values in the userform after textbox2 and doesn't update the preceding textbox/combobox then it won't populate (meaning having an update for textbox5 and having no values in the preceeding control fields). I think it is an issue with the active cell reference? If the preceding userform/combobox is not populated the activecell gets screwed up? I have tried offsets etc to no avail. If just textbox9 has an update then I need the code to find the match row=value in column A and then populate the referenced column of that row.

Another requirement for updating is that if nothing is entered in a textbox/combobox then it will not update with BLANK/No value and remove a field value that was entered earlier.


Any help is so appreciated.