Capture Form Code

Sorry...Sure it's simple..How can I create a from and then capture the
code which will produce it?

TFYT
Paul

 

Not in vba. In .Net, its automatic.
Create a form and then add controls to the form's Controls collection and
set their properties. Then you would have to get the IDE object and add code
to buttons, etc. But why?

 

Ed,

I'm working on a class that creates a tabbed form who's tabs and
data on each tab depend on number of walls and opening within said wall.

I figured I would need the code to do such? Or am I off track?

Thank You,

Paul

 

vb or vba?

--
----
Ed
----

 

sorry...Working in vba right now..but will use whichever I need to.

 

If you were working with vb, I'd create a control which would include a base
form. Since you are working from vba, remember that a form's module is a
special class module bound to the form's resources. You can add properties
and functions to the form like you would any other class. That way you can
start out with some controls on the form and you don't have to start from
scratch. For example, add a tab control and a property to the form for the
number of tabs. Then in the Load event, check the property to add the
correct number of pages to the tab control. Think of the form.Load event as
the class.Initialize event.

 

Thanks Ed...Could I borrow your brain for the weekend?/// "Rent a Brain" I
like it...)

 

No way! "Weekends were made for <insert favorite beer>."

 

You don't need your brain for beer...I would be just helping it out,
wouldn't tax it much...ha