I need to create macros that will enable me to insert repeat comments boxes
in multiple cells.

There are a number of different comments boxes I'll need, all single words:
Spanish
French
Italian etc

Any advice on how to do this much appreciated, I've never used macros before.