View Single Post
  #8   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

This seems explicit to me ...

I know I can create a new userform with new controls and new code for the
controls on the fly using VB.

--
---
HTH

Bob


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



"Dave Peterson" wrote in message
...
I think you misread the OP.

The subject adds more info, too.



Bob Phillips wrote:

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


--

Dave Peterson