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......
