excel vba - how to update the user form text box value in cell value after validate the other cell values -

excel vba - how to update the user form text box value in cell value after validate the other cell values -

i have 1 worksheet called "leave" having multiple rows , columns line "staff id, staff name, holiday date , comp off date". have userform select staff id combo box , other details name , holiday date select worksheet "leave". have text box on userform comp of date. update text box , click on command button called update data. on click want update column in worksheet (comp off date) value of user form textbox input value after comparing cell value of staff id , holiday date user form data. there may multiple rows same staff id in excel worksheet combination of staff id , holiday date unique. please help me write vba code...

regards, sandeep

excel-vba