Fill Userform From Database

[esperanto234]

Hi, This is the Ultimate Question!!!

I already finished my program in VBA, it has a userform for filling data into Word.

It has a bunch of textboxes.

But people has to fill de information into the textboxes every time they open the userform. Information that is already in a databse in excel.

My question is: How can i do to fill automatically some textboxes in the userform, when it's open, base on a database in excel??

This databse has in every line a unique ID, so it's impossible to repeat the same subject.

For example:

ID NAME ADDRESS PHONE
1234 Phill Smith Street 0987655543
1443 Eddy Lincoln Street 0923455668




TEXTBOXES NAMES:
id.text
name.text
address.text
phone.text




THANK YOU VEEEEEEERY MUCH

[smartchap]

On loading form, open the excel file having records. As records are in rows, having unique id, search for the id for the user and get the required data from columns to fill the text boxes.