User form and VBA

[lparri]

Hi Everyone! I was hoping someone could help me with something? Please. I am very inexperienced with VBA and am trying to create a user form that will pull data from a table. Basically what I would like to do is type into one field box and have all of the other fields populate. Right now my table is not very large but I will be expanding it. I created the table, a user form and a control button. I was able to get the control button to open the user form but I am unable to get the form to populate. I have searched and searched online for answers and I can't seem to figure it out. I'm certain to a seasoned VBAers it will be a no brainer. Thank you for any help you can offer. The spreadsheet is attached. Lisa

[torachan]

Your code should be in the UserForm module.
Placed elsewhere you need to reference everything back to UserForm so pointless in a simple case such as this.
File attached with modules removed and the basics needed in the UserForm.

[lparri]

Thank you. I figured it would be something an expert would look at and say...this is sooo simple. Again, thank you very much!!!