Hello everyone!

I am totally new to VBA code and I was wondering if some one more experienced could help me a bit on this one.

So, I am creating forms to automatically fill in my excel spreadsheet. I'm only using text boxes in the forms (and labels).

This is a sequential fill in process and the objective is for the user to only see the actual sheets of the excel file once he already passed through the process of filling in the forms.

However it would be great if I could import data from a different workbook and had it automatically fill in the fields in one of the forms.

To do this, I was wondering if I could, for example, create a command button that would open the external worksheet and copy the data the user would select into the form of the working excel and close the external data source spreadsheet.

Is this possible? Could you give me some tips?
Please, it would be great.

Thank you!

Cat