EXCEL VBA

[Belo85]

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]

@Belo85 

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.

[#3]

@SqueakySneakers 

Thanks for your help I appreciate.... I already got a solution....