EXCEL VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1640042%22%20slang%3D%22en-US%22%3EEXCEL%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1640042%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Good%20Day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20my%20excel%20issue%20about%20coding%20in%20vba.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20have%20here%20combobox1%2C%20combobox2%2C%20textbox1%2C%20textbox2%3C%2FP%3E%3CTABLE%20width%3D%22412%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22144px%22%20height%3D%2230px%22%3ELAST%20NAME%3C%2FTD%3E%3CTD%20width%3D%22145px%22%20height%3D%2230px%22%3EFIRST%20NAME%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3EM.I.%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3ESUFFIX%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22144px%22%20height%3D%2230px%22%3ESMITH%3C%2FTD%3E%3CTD%20width%3D%22145px%22%20height%3D%2230px%22%3EJOHN%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3EJR%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22144px%22%20height%3D%2230px%22%3EBROWN%3C%2FTD%3E%3CTD%20width%3D%22145px%22%20height%3D%2230px%22%3EJAKE%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3ED%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22144px%22%20height%3D%2230px%22%3EWILDER%3C%2FTD%3E%3CTD%20width%3D%22145px%22%20height%3D%2230px%22%3EALEXANDER%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3EE%3C%2FTD%3E%3CTD%20width%3D%2261px%22%20height%3D%2230px%22%3EIII%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecombobox1%20%3D%20Last%20Name%3C%2FP%3E%3CP%3Ecombobox2%20%3D%20First%20Name%3C%2FP%3E%3CP%3Etextbox1%20%3D%20Middle%20Initial%3C%2FP%3E%3CP%3Etextbox2%20%3D%20Suffix%20Name%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20auto%20populate%20two%20textbox%20values%20based%20on%20two%20combobox%20values.%3C%2FP%3E%3CP%3EAlso%20I%20want%20combobox2.value%2C%20combobox1.value%2C%26nbsp%3B%20textbox1.value%2C%26nbsp%3Btextbox2.value%20%26nbsp%3Bwill%20concatenate%20in%20one%20cell.%3C%2FP%3E%3CP%3EIt%20will%20appear%20like%20this%3A%3C%2FP%3E%3CP%3EJOHN%20A.%20SMITH%2C%20JR.%3C%2FP%3E%3CP%3EJAKE%20D.%20BROWN%3C%2FP%3E%3CP%3EALEXANDER%20E.%20WILDER%2C%20III%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20thanks......%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1647729%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647729%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780320%22%20target%3D%22_blank%22%3E%40Belo85%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20ask%20your%20question%20Excel%20community%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%26nbsp%3B%2C%20discussions%20here%26nbsp%3B%20are%20about%20Techcommunity%20resource%20itself.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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......

1 Reply

@Belo85 

Please ask your question Excel community here https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat , discussions here  are about Techcommunity resource itself.