Yes, not hard to do at all:
Create the userform, add the combobox. Open up the Properties for the
combobox and under RowSource put the address of the range that includes your
customers and SSNs. Add a textbox underneath. Then, right-click on the
combobox and choose "View Code." In the VBA editor, put the following (make
sure you use the names of your controls, if they are different than ComboBox1
and TextBox1):

Private Sub ComboBox1_Change()

TextBox1.Value = ComboBox1.Column(1)

End Sub


"MESTRELLA29" wrote:

I have a form and want to include a Combobox that is linked to a Customer
excel Sheet that has Name & Social Security

Once you selcet the customer I need to display the customer social security
bellow the name, can this be done?