From the article you referenced, I think this is more what you are
looking for:

Sub SetFormCaption(frmstart)
Set MyForm = VBA.UserForms.Add(frmstart)
MyForm.Caption = lblCaptionTitle & ": " & MyForm.Name
MyForm.Show
End Sub

There is also an issue with the scope of the MyForm object, so if
you want to Show it outside of the SetFormCaption sub, MyForm must
declared at a higher scope by placing

Public MyForm As Variant

At the top of the module.