View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pan65 pan65 is offline
external usenet poster
 
Posts: 10
Default Add code on the fly to existing userforms

I know I can create a new userform with new controls and new code for the
controls on the fly using VB. I have also added controls to an existing
userform but I am having trouble adding code for the controls. The name of
my userform is frmGSN and Code is a string of code. I am trying the
following code but it doesn't recognize the .CodeModule

With frmGSN.CodeModule
.InsertLines .CountOfLines + 1, Code
End With

Please help. Thanks