Forum Discussion
EXCEL VBA
Hello Good Day,
Can anyone help me my excel issue about coding in vba.
If I have here combobox1, combobox2, textbox1, textbox2
| LAST NAME | FIRST NAME | M.I. | SUFFIX |
| SMITH | JOHN | A | JR |
| BROWN | JAKE | D | |
| WILDER | ALEXANDER | E | III |
combobox1 = Last Name
combobox2 = First Name
textbox1 = Middle Initial
textbox2 = Suffix Name
How to auto populate two textbox values based on two combobox values.
Also I want combobox2.value, combobox1.value, textbox1.value, textbox2.value will concatenate in one cell.
It will appear like this:
JOHN A. SMITH, JR.
JAKE D. BROWN
ALEXANDER E. WILDER, III
Please help me thanks......
2 Replies
Hi Belo,
Not sure these require VBA.
If your chart begins in A1, to concatenate in E2 you can put =CONCATENATE(B2&" "&C2&". "&A2&IF(D2="","",", ")&D2).
You will need to give examples on "How to auto populate two textbox values based on two combobox values." This can be done with a formula as well but we will need to know what combobox choices will result in what textbox answers.
