I created a form that collects data from 2 different sheets, and in the output sheet if there are blank cells they need to be filled with values as written above

the position of my controls change after clicking on them, despite my attempt to fix position by the code below. Is there anything else I should do? Please help.

I am currently working with a large a series of data sheets at various lengths (1500-15000 lines) that record training records for employees. The current system built by a previous employee has no automation and takes a very long time for the department that utilizes the sheet to update it. Since they have to go to each employee to add the course.

I have 2 Excel file with same format but one is Master file (for calculating) and one file is extracted data from system. I want to copy extracted file’s data to Master file with VBA but it didn’t work.

Trying to create a userform in VBA excel where in the text can be scrolled vertically to show what I add in specific cells of excel. I am using version 2016 of excel.