vba - Excel Macro for check mark to add a string at the end of an existing string for select cells in a row -

i'm wondering how can create, in vba, macro activex control checkmark add string @ end of existing string select cells in excel

i have table of teachers associated classes teach, , want checkbox can select if they're bilingual. in event they're bilingual, adding string course name allows me use countif function find how many classes taught in each of 2 languages.

thanks!

you can need excel functions.
first of activate de developer ribbon (rigth click on ribbon -> customize ribbon -> check developer tab).
in developer tab, click on insert -> checkbox. put checkbox wherever want, right click on , select format control -> control, , set cell hold status of checkbox, in "cell link".
cell hold values true/false, if() function can concatenate() suffix or whatever want.