Autofill Form fields from external spreadsheet - Help please!

[CatTx]

Hello everyone!

My name is Cátia and I'm new member, first post!

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.

PS-MSOffice2010

Thank you!

Cat

 

[vletm]

Are You really new with VBA?
I send one sample, but I wasn't sure what do You really want.
This sample don't have connection to any external file, but it works same way.
If this file knows user, it will show some of users information ...
if not ... user have to select with Cell [B2].
The Form has labels and textboxes.
Textboxes values has filled automatic (from 'somewhere').
[Cancel] hides the Form and [OK] sends Form's information to basic Sheet.
You wanted to select external into Form ...
It need different objects; Listbox or something else..
You have a vision of Form, send it.
Ideas?

 

[CatTx]

Hello,

Thank you so much vletm for your advice!


After much "research" I ended up using an inputbox, and it works now.


Cumps,
Cat