I am trying to export several Forms that I have created using VBEditor. I am
not aware if this is possible or the correct syntax to export the form to a
text file and then upload the form to another worksheet automatically. I
have approximately 40+ spreadsheets that need to have the same form in each
file. I have done this successfully with Modules but not with Forms. Is it
possible to export and import automatically? Here is a sample of the syntax
that I used for the modules......

With Workbooks(RollUpProg)
FName = .Path & "\code.txt"
.VBProject.VBComponents("InventoryWalk2").Export FName
End With
Workbooks(datafilename).VBProject.VBComponents.Imp ort FName