auto populating off of username

[KLahvic]

I have just had the problem of autopopulating the user name in one of my user forms off of a log in screen. My next question for guidance is, if I have a user name that represents the owner of a distributorship, then is there a way to populate the distributorship name, and address information just based on the user name entered? I figure vlookup is the way to go, but I am not sure how to use it, I know vlookup should be easy to use and if I can't I shouldn't be using vb, but I have a solid working program but do not know how to use vlookup for this instance.

Any help would be greatly appreciated.

I will attach my workbook for your reference.

logi in: tester
password: test01

Programmers access password: 1234

[royUK]

I would use the .Find method in VBA, there's lots of examples here and the VBA Help file example is good.