lookup row, populate userform textboxes, amend and save changes to original row

**rich23l** · 08-13-2012, 10:09 AM

Hello,

Hoping someone can help out, I've only ever needed to do basics in excel but now looking to branch out a little and trying to learn as I go.

I need to import data from a single row (9 columns worth) into a userform based on the manual input into textbox 1 (TxtDocNo) which searches column 'A' (filled with unique numbers). I then need to amend the data where required and save it back to the row from which it was imported.

This is some import code I found, which keeps returning an error requiring an object

Please Login or Register  to view this content.

----

Here's the code I use to create and validate a new record, can this be amended to work with the existing "found" row and overwrite.

Please Login or Register  to view this content.

Would appreciate any help,
Cheers, Rich.

**Cutter** · 08-13-2012, 11:38 AM

@ rich23l

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.