Hello all this is my first post, I need some help please. I am still learning vba bit by bit. I have created a user form that is to calculate duration of part process based on quantity and cycle time. There are two criteria to attain the cycle the part number and the operation number as you will see in the sample file attached, How is the vba code written to lookup a part number and its associated operation sequence to populate the textbox with the correct cycle time to allow the multiplication to occur, I can do the maths in vba, I can do this in excel as you will see in the data sheet but the vba code alludes me. Thank you in advance