Macro to insert repeat comments

[claraloupot]

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.

 

[claraloupot]

To show you how far I've got so far. I've tried to record manually and have
the following:

Sub French()
'adds French comment
ActiveCell.AddComment Text:="French"
Set cmt = ActiveCell.Comment
With cmt.Shape.TextFrame.Characters.Font
.Name = "Times New Roman"
.Size = 8
.Bold = False
.ColorIndex = 0
End With
SendKeys "%ie~"
End Sub

But get an error message that says "can't execute code in break mode".

 

[JLGWhiz]

It worked OK for me. I got a comment dropdown box that has the word French
in it.