Good Morning All.

Hope you are all doing well.
is it possible to get some help here from you guys ? with VBA . When select branch , VBA to fill Address, Tel No, Manager by automaticle and any other boxes to be filled up manually. when saved, pastes information on form to Maintaintance sheet. from A15 - K15
Also when clicked on Print button , i need userform to be printed as shown on table
I have attached the file in detail, i belive that would help to get better understading of project.

I would really appriciate if anyone of you could help.

Thank you and have a good days.

Benjamin
Projects.xlsm