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?

Thanks it Works Wonders...

Question, did you take an Excel training to know how to built userforms?

"K Dales" wrote:

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?

As far as training, no, I am pretty much self-taught, but that comes after
years of programming in other computer languages. There are many books out
about VBA (Visual Basic for Applications) that can teach you about the
subject, as well as some good online tutorials, etc. This newsgroup is also
a big help. Many contributors, especially the MVPs, have websites with lots
of Excel info!

"MESTRELLA29" wrote:

Thanks it Works Wonders...

Question, did you take an Excel training to know how to built userforms?

"K Dales" wrote:

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?

THANKS...

I have a lot To Start Learning,

"K Dales" wrote:

As far as training, no, I am pretty much self-taught, but that comes after
years of programming in other computer languages. There are many books out
about VBA (Visual Basic for Applications) that can teach you about the
subject, as well as some good online tutorials, etc. This newsgroup is also
a big help. Many contributors, especially the MVPs, have websites with lots
of Excel info!

"MESTRELLA29" wrote:

Thanks it Works Wonders...

Question, did you take an Excel training to know how to built userforms?

"K Dales" wrote:

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?