I want to add a variable to an inserted line, but I can't seem to get
the syntax right.

I have for instance:

With TempForm.CodeModule
X = .CountOfLines
Dim y

for y = 1 to 10
.InsertLines X + y, "MsgBox ""This is message "" & y"
next y

End With

The code is inserted into the module, but this is the result for each
MsgBox:

MsgBox "This is message " & y


I just can't seem to get the variable to be part of the code.

Any help will be appreciated.