Sep 04 2020 06:27 AM
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......
Sep 09 2020 08:43 AM
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.
Sep 09 2020 08:56 AM