UPDATE DATABASE IN EXCEL SHEET WITH THE HELP OF USERFORM

[Khanzaki]

HI ALL , WILL TRY TO EXPLAIN AS SIMPLE AS POSSIBLE
SO I HAVE A USERFOM WITH 80 CONTROLS(TEXTBOXES ,COMBOBOXES ) I HAVE NAMED THEM AS "FIELD" FOLLOWED BY A NUMBER
EG. FIELD1 ,FIELD2,FIELD3 UPTO FIELD80
DATA FROM THESE FIELDS ARE ADDED TO THE DATABASE SHEET IN EXCEL BY ADD BUTTON ( I HAVE USED LOOP VBA TO ACHIEVE THIS) THIS WORKS FINE UNLESS I HAVE THE NEED TO UPDATE PREVIOUSLY ENTERED DATA
I AM LOOKING FOR A SOLUTION THAT SHOULD LOOK FOR VALUE OF FIELD1 IN DATABASE SHEET AND IF A MATCH IS FOUND IN SOME ROW , THE DATA FROM ALL CONTROLS SHOULD GO INTO ADJACENT COLUMNS OF SAME ROW (i.e. IF FOR EG. FIELD1 VALUE IS FOUND IN ROW NO4 ,THEN FIELD2 VALUE SHOULD GO IN (4,2) FIELD 3 IN (4,3) AND SO ON UPTO (4,80)
WAITING PATIENTLY FOR YOUR KIND RESPONSES

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Update data of selected row using userform
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Khanzaki]

Cross Posted at Update data of selected row using userform