EXCEL VBA

New Contributor

Hello Good Day,

 

Can anyone help me my excel issue about coding in vba. 

If I have here combobox1, combobox2, textbox1, textbox2

LAST NAMEFIRST NAMEM.I.SUFFIX
SMITHJOHNAJR
BROWNJAKED 
WILDERALEXANDEREIII

 

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

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

@SqueakySneakers 

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