Select Row from worksheet and update by userform

**herghost** · 01-13-2012, 10:11 AM

Excel 2010

Hi all, I have a worksheet where the data is entered from a userform which all works lovely.

There is more data that needs to be added to the row some time after the initial record is entered.

What I am aiming at is a new userform to update the row. I have created the form and the 1st box is the id, which is an 8 digit number unique to each entry, the second box is the customers reference

What I need to do is enter this 8 digit number, the customers reference will appear in the 2nd box for validation (already entered in form 1) and then fill in the rest of the data and then save it to the same row with an offset of 8 columns. I have searched the web for days looking for an example I could use, but I cant seem to find anything that directly relates to what I am trying to do.

Could anyone possible give me any hints on where to start or a link to a code example, starting to drive me nuts :p

Many Thanks

Dave

**mccrimmon** · 01-13-2012, 10:48 AM

So let me understand this correctly.

You basically want to enter the Unique Reference on the second form and once you have entered the data you want that unique reference rows data to be updated on the sheet?

**herghost** · 01-13-2012, 11:27 AM

Hi McCrimmon,

Correct, thats exactly what I am after.

Basically (example only!(
Form 1

A,B,C,D is entered

Form 2
A is entered, B is shown just for validating correct id, E F & G are entered and added to the existing row for ABC&D

Hope that clears it up!

**john55** · 01-13-2012, 11:48 AM

hi,
as an option
try and see if it helps you. adjust it for your needs.
(call the userform and type "id", it will be displayed...then change teh info!)