Hi! i tried to program an user form in excel but had the following problem. Lets assume that I have a data table and the first column is ID column. I want to create an user form that contains four textfields. When i fill an id number in the first textfield a macro should check the column A for that ID and if it finds the same then the macro should assign to the other three textfields of the userform the values in the columns B, C and D in the same row where the ID was found. I hope somebody could help me with the code!