userform finds and updates data line- object variable error

Almost assuredly it is because foundcell is Nothing, i.e. your .Find didn't find anything, so there is nothing to offset. You can remedy this situation by doing this:

Please Login or Register  to view this content.

But I think your larger question would be why you're not finding anything, but that I can't address without seeing your worksheet.

It's because you have Formulas in column A, which .Find is going to look at by default unless you tell it not to. So it tried to match the string in your combo box to the formulas in column A, and of course found no matches. So you need to tell it to look at the values the formulas create. Using this line below, it did find matches.

And it's still good practice to use my suggestion above, so you don't error out when there are no matches. You could also add an Else statement to that with a msgbox of "no matches found" or whatever.

Please Login or Register  to view this content.

You don't need to use Find to get the row of the selected client in the combobox, you can use the combobox's ListIndex property.

Please Login or Register  to view this content.