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

You said you were creating a new userform, I just gave some code that
included that creation as well as the controls and the code.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pan65" wrote in message
...
I am gathering from your response and from Bob's response, that I just need
to start with a new userform.

Thanks for the help, it is much appreciated.

"Dave Peterson" wrote:

Another option would be to create the userform with those controls on
it--and
the code behind those controls, too.

Then just hide/show the controls you want hidden/shown.

pan65 wrote:

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


--

Dave Peterson