Userform Load Questions

[RobertCo]

Hello again,

I am in the process of creating a userform which I would like to have populated once a User makes their selection.

I have the form created and have some of the functionality working but I am having a problem understanding how I can populate the remaining Fields on the form using a lookup.

The basic flow of the form should be as follows.

User opens Excel file (form opens with no options)
....(currently I am autopopulating the form with the IP Column)

User selects one of the 4 OptionButtons to determine what list will populate
ListBox1
Once ListBox1 is populated User will then select from that listbox and the rest of the form will be popluated with the corresponding data elements.

My thoughts on how to do this were to initialize form
Once the option has been chosen and the user clicks on the selection,
a Macro to do a vlookup would fill the remaining fields.
1. Is vlookup the correct choice for this process or is there a better method ?
2. How would Vlookup pass the variables to the Form textbox when the Textbox does not know the position in the datasheet where the original variable was loaded from ? This is what is confusing me.

TextBox1.Text = (vlookup(ListBox1.Value,A:I,2)) ???

I have attached a sample of what I am trying to accomplish
Thanks again for all your help, this is really a great learning process for me.