Combo Box w/text boxes for relation to combo box

[borchardt]

I would like to add VBA for when needed with a combo box with the text boxes relating to the combo box data selected.

Example data:
text1 text 2
ComboBox Acct No Phone
1st National 123456780 888.530.3626
Kohls 123456781 800.528.4800
BOA 123456782 800.421.2110
Cap1 123456783 800.955.7070
Amex 123456784 877.435.7330
BMO 123456785 800.564.5740
City of Olathe 123456786 877.602.8220
ATT 123456787 888.231.1234
Direct TV 123456788 600.383.1183

 

[SkipVought]

hi,

What application?

What is your business case?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

It is very hard to see your:
Example data:[pre]
text1 text 2
ComboBox Acct No Phone
1st National 123456780 888.530.3626
Kohls 123456781 800.528.4800
BOA 123456782 800.421.2110
Cap1 123456783 800.955.7070
Amex 123456784 877.435.7330
BMO 123456785 800.564.5740
City of Olathe 123456786 877.602.8220
ATT 123456787 888.231.1234
Direct TV 123456788 600.383.1183
[/pre]

Is that what you wanted to show?
If so, please use TGML tags: [tt]
[ignore][pre]
some text
[/pre][/ignore][/tt]

Have fun.

---- Andy

 

[borchardt]

Needing VBA form (that is already created) that I can call through a macro that will populate combo box with the accounts, then when I have selected the account through the dropdown in combo box the account number and phone number will populate in the two text boxes. Needing help in getting started with code to populate combobox and the relationship fro cobobox to text1 box and text2 box. I can send spreadsheet if needed.

Combo Box text1 text2

Account Acct No Phone

1st National 123456780 888.530.3626
Kohls 123456781 800.528.4800
BOA 123456782 800.421.2110
Cap1 123456783 800.955.7070
Amex 123456784 877.435.7330
BMO 123456785 800.564.5740
City of Olathe 123456786 877.602.8220
ATT 123456787 888.231.1234
Direct TV 123456788 600.383.1183

 

[PHV]

What have YOU tried so far and where in YOUR code are you stuck?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

You imply that you are using Excel.

You could use INDEX() & MATCH() to lookup and return data for the account & phone to each textbox, referring to the source table.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]