Hi, I am quite inexperienced in VBA but none the less I have managed to
create a userform to load data from the various text and list boxes
into the next blank line on a worksheet.
What I am trying to do now is to search for a particular reference
number which is on the worksheet (there will be several thousand
entries)and then automatically display a second userform that loads the
currently entered data for the row containing the reference number into
the userform, the user will then add more data into an number of extra
text boxes and possibly amend the existing data, all the data will then
be loaded onto the correct row in the worksheet.
Getting the data from the userform into the worksheet I think I can
do(apart from one problem)the trouble that I'm currently having is
searching for the reference number and populating the 2nd userform,
associated with that is how do I make sure that the data is being
entered onto the correct row, i.e the row containing the reference
number. I have purchased a number of books but none seem to have the
answers to my questions.

Any assistance would be very gratfully received