Hi,

I have a problem with looking up a certain value through a user form and then change the data in the row that value is in.

To find the right row I came to this code:
Formula: copy to clipboard
RowCount = Worksheets("Database").Range("A1").CurrentRegion.Rows.Count
Set Found = Worksheets("Database").Columns("B").Find(What:=Me.cbx_Omschrijving.Value, LookIn:=xlValues, lookat:=xlWhole)


To change the cells I had something like this in mind:
Formula: copy to clipboard
eRow = "Code, but no idea what"
.Cells(eRow, 1) = Me.tbx_Artikelnummer.Value
.Cells(eRow, 2) = Me.tbx_Omschrijving.Value
.Cells(eRow, 3) = Me.tbx_Eenheid2.Value
.Cells(eRow, 4) = Me.tbx_Voorraad2.Value
.Cells(eRow, 5) = Me.tbx_MinVoorraad2.Value
.Cells(eRow, 6) = Me.tbx_MaxVoorraad2.Value
.Cells(eRow, 7) = Me.tbx_Locatie2.Value
.Cells(eRow, 8) = Me.tbx_Leverancier2.Value


What I want to achieve in text: There is product data in rows and columns. Through a user form I select the right product. In text boxes the data of this product appears. In a 2nd set of text boxes this data also appears. In this 2nd set of text boxes I change the data and leave the data in the 1st set of boxes untouched. By a command button the data from the 2nd set of boxes should be put in the right row, by looking up the original product from the 1st set of boxes.

Thanks for the help in advance!